After Update in Form

bennybee

Registered User.
Local time
Today, 05:01
Joined
Jan 13, 2004
Messages
50
I have a table which stores different agendas for meetings. (Agenda meeting number is the primary key - auto number), and there is a field - Meeting Date - which is where the user enters the date of the meeting.

i have another table called hearings. now some meeting agenda items become hearing items.
the hearing table has a primary key (Hearing agenda number), and has the field - Meeting Date, which is a lookup value of the Meeting Date field in the Meeting Agenda table (so it will only show in a drop down box those values which have been entered).

what i want to happen is that once a user selects a date, thats in another field in the Hearing table, the drop down box is effectively filtered, to only show those meeting agendas that happened for that date. so that the user can then select the meeting agenda which is now being heard in a hearing.

how can i do this - the filtering of the Meeting Agenda dropdown box, to only show those records that apply to the date stated in the Meeting_Date in the meeting agenda table, are displayd in the hearing table.?

can i do it via a query?
i can set up a query that will filter the data down when i put something in the "criteria" section. and then run the query.
can i somehow associate the value in a field to be this criteria, so that its dynamic??
 
It might be easier and make more sense if i explain it this way.

I have a query that gives out the data that i want it to, but i have to enter the input value either by hand (via a popup box) or i enter it into the Criteria section in design mode.

is there a way once i make a form based on this query, that i can assign another field to be the input box, for which the query is then run on?

so when i enter a date, it runs and will display the agenda items associated with that date...

that make more sense?
 
You need to use an expression to point the query to the text box in your form. The criteria field in the query that you want to filter with the forms text box should look something like this...

[Forms]![YourFormNameHere]![TextBoxNameHere]

HTH
 

Users who are viewing this thread

Back
Top Bottom