Help with List box to subform update please??

  • Thread starter Thread starter CP
  • Start date Start date
C

CP

I am trying to auto update a subform with a selection I have clicked on in my
list box

Lets imagin a car workshop
Data1 = Car plate, model, year (uniqueid is carplate)
Data2 = WorkRef, Car Plate, In, Out (uniqeID is workref, lookup field on
carplate)

The form has a list box from Data1 just showing each car plate, and a
subform (in Dataview) showing all the work ref and details for the respective
car plate.

As you click the car plate on the list box it changes the details on the
subform

I have a "me.Requery" on the list box on the afterevent
Any help would be appreciated
 
If you have set the subforms Link Child Fields & Link Master Fields in the
Subforms Data Properties, the subform should update automatically when the
parent form is updated to the new record. If the main form is Unbound I would
bind it to the table Data1 and include a field carplate (hidden if preferred)
on the main form to ensure the automatic updating of the subform.

TonyT..
 
Back
Top