Difficulty opening form of specific record from another form

[Pedigreeman]

Hello all,

So I have two tables each with a respective form.

tbl1 frm1
tbl2 frm2

tbl1 stores the bulk of the information, and occasionally further information will be stored about a particular record in tbl2. Tbl2 does not list all records, but only those that have additional information.
Both tables have an ID field. For tbl1 this is the primary key and an autonumber, for tbl2 it is an indexed number with no duplicates allowed. I have created a 1 to 1 relationship between the two tables, linked via their ID fields.

I have created a button in frm 1 using the wizard, which opens frm 2 based on the current record by matching the two ID fields.

When I am on record 6 for example on my frm1, I press the button, it opens up frm2, but it has not entered '6' in the ID field, it is simply blank. I had hoped it would autofill in the '6' based on the fact that I opened a form for that record. On entering data it does not enter the '6' the ID field remains blank, and when I try to save, it comes up with a 'cannot find record...error' presumably because there is no existing record in which the ID field is blank (this is not allowed by the autonumber/primary key field anyway). When I enter '6' manually, everything works fine.

Any suggestions? What am I doing wrong?

Many thanks,

Mark

 

[jdraw]

Please show the code associated with the button. And any other details.

 

[Pedigreeman]

Please show the code associated with the button. And any other details.

Its an embedded macro the criteria of which is: ="[ID]=" & [ID]

Would I be right in thinking the point here is that it cannot match the ID number of tbl1 to the ID number of tbl2 simply because tbl2 has no records and therefore no ID numbers to match?

If this is the case, I need to find a way to get this button to open the form and if there is no record of the current record in tbl2, it needs to create one.

 

[Pedigreeman]

I have now found out that if the records already exist in tbl2, then the form button will direct me to the correct record, by matching the ID fields in the two tables.

Might the solution be to populate the tbl2 ID field with the exact same data in the tbl1 ID field (i.e. 1-600)?

If so, how would one go about doing this?

Many thanks