Radio Button Problem

[SachinPatel]

ChipR,

Good news i have figured the radio button issues out with some SQL and some VBA functions.

Thanks for you support.

I am still trying to diaplay all macthing types in the list box (Username Matches....) to the names i insert in the username combo box.

any ideas? please see below for the names of each object .

What i am trying to to is one a user selects active / inactive or All, they then proceed to typing in a username in the combo box called 'cbonames' as they start typing a list of all corresponding usernames in the users table (users) appears in the list box called 'lboxusernames'

once name found there should only be 1 entry in 'lboxusernames' and i want the user to click on that name to have it displayed in the 'cbonames' field.

i also require the updating of data if i was to delete a name in the cbonmaes field and start typing fresh the names should disappear from the boxusernames field and update with new chrecters im placing in, requery???

any thoughts or ideas would be great!

Thanks again ChipR

** Admin Edit - This post hijacked thread Access 2003 - forms and radio buttons **

[ChipR]

I'm confused as to why you are using a combo box, and I can't tell where you're stuck. Do you want to post the code you have?

[SachinPatel]

Chip,

Attached sample database.

If you look at the form (issueslog) the user will need to select one of the option groups first then the Username combo box becomes enabled.

Once enabled the user can start typing in a name based on the option group selection and whilst typing in a name i would like the list box to the right (Username Matches) to show all the suers that match the name

for instances if i had 3 users with surename Shah who were all active if i selected Active in the options group and type in 'sha' i should see all the users with their username starting with 'Sha' in the username matches column allowing me to select one.

i have dummy duplicate names in teh users table to try and solve this.

If using a combo box is incorrect please cna you support in showing me the right way.

Thanks mate - this is greatly appreciated.

[ChipR]

Sorry, I can't download anything here. I do understand what you are tying to do, and you aren't using any of the functionality of the combo box. You are just using it to type into like a text box, yes? All the relevant code will be in the Change() event of the input box, so please post that if you can.

[SachinPatel]

the funny thing is i have no text in the change event of the input box

Just to confirm by input box you mean the combo box where i enter the username or the text box that i would like to see the similar username results listed ?

For the combo box (username) i have sql in the row souce

for the text box (username matches) i currently have a non working sql query.

??

[ChipR]

The input box is the control where the user types in input. As far as I can tell, there is no reason this would be a combo box, so I would assume a text box. The list of matches would be shown in a list box.

[SachinPatel]

I have used a combo box and created sql in the Row source to bring the fields required from the users table back to that box.(as below)

SELECT   Users.[Actor Name],
         Last_Name & First_name AS Fullname,
         Users.LAST_NAME,
         Users.FIRST_NAME,
         Users.Status,
         Users.Email,
         Users.IS_LOCKED,
         Users.Description
FROM     Users
WHERE    (((Users.Status)=Forms!Issueslog!optStatus))
ORDER BY Users.LAST_NAME,
         Users.FIRST_NAME;"

optstatus is the option group i am using for active/inactive and all users.

I can laternatively use a text box and instead write the sql in the control source field - however that still leaves no coding in the change event field?

would you suggest changing combobox to a text box?

if so how would i apply that query to the text box?

[ChipR]

We are not on the same page here. Initially, you planned on having the user type in one control, and display the list of matches in another control. That's the method I have been explaining, so perhaps reread my posts from the beginning with that in mind.

[NeoPa]

Sachin,

As a very new member I will avoid a formal warning in this case, but I suggest you check out our rules (Site FAQ) before posting again, as you've fallen foul of a couple of them already.

Thread hijacking is quite serious (usually. We make allowance for new members of course). Posting code without tags is also against the rules. Posting SQL in a single long line is not illegal, it's just not going to encourage anyone to look at your problem. The bright thing to do is to format it readably first.

Having said all that - Welcome to Bytes!