Simple Problem

[denileigh]

At least I think it is....I'm just stuck, I swear I have done this 20 times and can't figure out why it is not working today.

I have a WorkOrders table which has:

WorkOrderID (auto number)
Car
Number
Arrival
etc.....

and a table which has:

GEID (auto number indexed field)
WorkOrderID
Date Sumbitted
Approval Amount
Status
etc

I have a form with information from the main workorder table and am tyring to open a subform to enter the GE records pertaining to the main file.

I set it up to upen and display all the records with the matching workorderID but it is not working.

For some reason the subform isn't recording data and when I open it up, the workorderID is O instead of the id from the main form.

Is it something simple I am doing wrong?

Thanks for your help.

Dianne

 

[gemma-the-husky]

do you have a control on your form, or a variable called workorderid.

when you add the subform to the main form, does it automatically confirm the link reference. It should, or you can set it manually