- Joined
- May 18, 2010
- Messages
- 1
- Reaction score
- 0
I have three tables:
car table:
carid
engieeid
repaire type table:
repair_type
car_repair table:
carid
repair_type
I have a parameter query:
to query car_repair table according carid. The paramter is carnumber.
A form, table resouce is car table. Only two control: one banding to car table - > carid.
The other one is listbox, row source is the parameter query:
1. How could I update the listbox when nevegating the records by clicking |> or <| buttons?
2. Why I open the form it not pop up the parameter dialog?
3. How could I implement the add / delete function to the car_repair table through the query?
Thank you very much!
car table:
carid
engieeid
repaire type table:
repair_type
car_repair table:
carid
repair_type
I have a parameter query:
to query car_repair table according carid. The paramter is carnumber.
A form, table resouce is car table. Only two control: one banding to car table - > carid.
The other one is listbox, row source is the parameter query:
1. How could I update the listbox when nevegating the records by clicking |> or <| buttons?
2. Why I open the form it not pop up the parameter dialog?
3. How could I implement the add / delete function to the car_repair table through the query?
Thank you very much!