B
Bill Phillips
I have a form containing a number of inventory records I
need to identify. This form has an option group that calls
a subform to specify identifying the records by my item
ID, the vendor ID or the warehouse location. When I
identify the item using the subform I change a flag on the
item to show that it has been identified. I then close the
subform and requery the original form to exclude all
identified items. My problem is that when I return to the
original form I would like to go to the next record. I
would like to use the DoCmd GoToRecord, but I need to use
a variable name for the offset. Can this be done?
need to identify. This form has an option group that calls
a subform to specify identifying the records by my item
ID, the vendor ID or the warehouse location. When I
identify the item using the subform I change a flag on the
item to show that it has been identified. I then close the
subform and requery the original form to exclude all
identified items. My problem is that when I return to the
original form I would like to go to the next record. I
would like to use the DoCmd GoToRecord, but I need to use
a variable name for the offset. Can this be done?