Conditions refered to value of list box

[Dominaz]

Hello again,
I've a doubt of how to make where conditions refering to the value of a list box in a form, I'm going to explain it:



I've a form which show me information about bookings (name, date,etc) which is stored at table_bookings ,I have other table with information of my clients, the point is I want a form where I can select a name of one client, and edit the booking details.

How can I do that???


Thanks.

[hertfordkc]

To get the result you want, you should create a query based on both tables and linked by name (runner id?). In the design view. put a runner's id in the criteria field, run the query and you should come up with most of the info which you need. Remove the criteria and save the query.
Then recreate your form based on the query.
At this point, you will probably want to have some means of either entering a runner's id and pulling up a name. If you get stuck, repost.

[Dominaz]

To get the result you want, you should create a query based on both tables and linked by name (runner id?). In the design view. put a runner's id in the criteria field, run the query and you should come up with most of the info which you need. Remove the criteria and save the query.
Then recreate your form based on the query.
At this point, you will probably want to have some means of either entering a runner's id and pulling up a name. If you get stuck, repost.

I've done what you said, but When I open the form it filter the data with the name I put on Query criteria, and I still don't know how to do a filter so in the form I only see the data related to for example one name..

[hertfordkc]

I've done what you said, but When I open the form it filter the data with the name I put on Query criteria, and I still don't know how to do a filter so in the form I only see the data related to for example one name..

You've formed the query correctly and it filters correctly. Note that I said
Remove the criteria and save the query.

Let me restate: Open the criteria in design view and remove the runner Id which you saved with the query. After you have removed the runner Id from the query, save it.
Open your form. You should now see the unfiltered results.

If this works, then you are ready to create the filter from the form.
I use brute force to link the box on the form to the filter. From whatever control that you are selecting/entering the runner ID, construct onevent (onclick, onupdate) code that inserts the runnerid into the filter and forces a requery.

See example here: https://www.accessforums.net/forms/f...xes-18492.html
oops. That is Access 2007. I'll try to find a 2003 link and repost.

[hertfordkc]

This link contains an example "db2 Mod" which should help you. Be sure to examine the objects and properties in design view, and also view any visual basic code.

https://www.accessforums.net/forms/c...lds-18541.html