autonumber and subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have two tables, one table has an autonumber as the key, the other table is linked to the first using this key. I created a form and subform. When I try to add a record, I can't tab down to the subform until I move off the current record from the main form. If I change the structure of the table so that the key is a number instead of an autonumber and require the user to enter the number, everything works, but I'm supposed to use an autonumber instead. Any ideas.
 
Changing focus from the main form to the subform should automatically save
the current record in the main form, thus having the same effect as moving
to another record and back again.

Are you sure you have the main form and subform linked correctly? You will
need a textbox on your main form bound to the autonumber field (it is usual
to make this textbox invisible to hide the meaningless autonumber). The
subform's LinkMasterFields property should be set to the name of this
textbox. The LinkChildFields property should be set to the name of the
related field (foreign key) in your second table.
--
Good Luck!

Graham Mandeno [Access MVP]
Auckland, New Zealand

miker said:
I have two tables, one table has an autonumber as the key, the other table
Click to expand...
is linked to the first using this key. I created a form and subform. When
I try to add a record, I can't tab down to the subform until I move off the
current record from the main form. If I change the structure of the table
so that the key is a number instead of an autonumber and require the user to
enter the number, everything works, but I'm supposed to use an autonumber
instead. Any ideas.
 
Back
Top