More on list boxes

  • Thread starter Thread starter Mario
  • Start date Start date
M

Mario

Hi,

I use form1 to search for a record. In the header of form1 I have the
ItemField combo box which search and prints an output in a list1 box located
in the detail part of form1.

If the searched record needs editing, I use command1 to take me to form2 and
automatically carries on the ItemField thus pointing to the right record. So
far so good...

If the record needs to be updated with additional information (like
maintenance to a vehicle...km, date, etc..) then I use command2 to take me
to the same form2. However, this time I want the form to clear up and add
new data to the record (storing the original one) not additional data (which
is accomplished with command1).

The information for list1 is drawn from table1 while the info for form2 is
drawn from table2. The two tables are linked with a common FldId.

Any guidance is appreciated.
Mario
ACCxp
 
Hi again,
Perhaps the following text may be helpful:

Table1 FldId, VehicleNumber, Dealer, Make, etc...
Table2 tblId, FldId, VehicleNumber, km, typeservice, etc...
 
Back
Top