Drop down box to find records (web database)

[antr]

Hi guys,
I am using Access 2010 and the web database so having a bit of an issue. I have tried google but no luck really - seems complex and confusing.

Basically I have a table which has column 1 of the unique id and column 2 is the project name.

When you click the drop down on the form, I want it to show column 2 (the project name) and when you click this, on the form I want it to find that record.

How on earth do I do this as I cant seem to

Thanks

 

[missinglinq]

Like the majority of the people who help out, here, I have no experience using Access' native web-based databases, and my knowledge as to what can and cannot be done with them is sketchy, at best. But here is a short tutorial for doing this in a standard Access database:

• Create a Form using your Table/Query as the Record Source.
• Go to the Field List and drag the Fields you want retrieved onto the Form
• Place a Combobox on the Form.

When the Combobox Wizard comes up:

• Select "Find a record on my form based on the value I've selected..."
• Click on Next
• Select the appropriate identifying field (in your case the project name) to appear in the Combobox
• Click on Next
• Size the Combobox column
• Click on Next
• Name the Combobox
• Click on Finish

Now the user can use the dropdown arrow of the Combobox to retrieve the data or simply start typing the identifying data in and the Combobox will start to autocomplete the entry. When the correct entry is found hit <Enter> and the appropriate data should be retrieved.

I assume that you can do the same thing for your web database. If it doesn't work, you've only invested a few minutes. Let us know how it goes.

Linq ;0)>

 

[antr]

Hi,
Thanks for your reply. For some reason the wizard doesnt work on the web based one which is daft. I could try and do it on another database and copy the settings so will give that a go

Thanks

 

[antr]

Just tried it and doesnt work - a log of the options seem to vanish for the web one