help with a subform

[Karen Skipper]

I want to have a subform that will display fields that are in the same table
as what's displayed on the mainform.

My project is for meters we produce and record the serial number for and
then when the customer returns the warranty card we want to enter the
address etc from the card. Most users won't need to see the address and I
wanted to have it appear on a subform that would be activated by clicking on
a button.

I can do this if there is only one record for a code/serial number BUT the
problem is that sometimes we sell a meter and it is returned still usable so
we resell it, so the meter is reentered in the database/table. (I'm a dbase
user from way back and changing to 'table' is difficult) When I lookup a
meter that has been sold twice I get the two records and can use the buttons
at the bottom of the screen to view each of them but when I click on my
address button I always see the address for the first of the records. My
lookup is done through a query and the mainform and subform are bound to
that query.

Also, I'd like to be able to clear all of the fields on the mainform when I
click on the save button.

Sorry for the long winded post!

Karen