Combo Box selection filling up data in access web app

[schteve]

Alright then. I am a complete noob when it comes to access web apps.

I already have a check-list created(in form of a database)

It is all in one table, like all the fields.

So what i want is to have a combo box from which i can select a customer, and all the details of this customer will be automatically populated in the form.

I've been stuck at this for quite a while now. Seen a few YouTube videos as well, but most of them were just on access(not web apps)

I'm not getting the combo box wizard for some reason, even when the magic wand kinda thing is turned on!



I have my database on share point.

Any help will be highly appreciated.

[June7]

You want to use unbound combobox to input filter criteria to find existing record. A parameterized query might work in web database. Was that demonstrated in any of the videos? Maybe a macro can set the form Filter property.

Getting the value from the combobox might require TempVars. Review another poster's experience with combobox in web db https://www.accessforums.net/access/...xes-40936.html

[schteve]

Many thanks for your response. I'm afraid I don't really know how to do what you said

I only created a simple database and published it on Sharepoint.


Can you tell me exactly what I should do?

Many Thanks
Schteve

[June7]

I don't use web database. I can offer examples that work in regular db but I am not sure if or how they could be translated into web db.

You don't know how to do what - a dynamic parameterized query? Here is one example http://www.datapigtechnologies.com/f...earchform.html

Did you review the referenced thread?