subform not synching (a2k)

Topic

New Reply

I’ve got an Order form that opens via a cmd button on the Consumer form. The Order form opens to a blank record and then pulls the value in the txtConsumerID from the main form into it’s own txtConsumerID. The underlying tables are linked by lngConsumerID.

I’ve placed an Address subform on the Orders form. The link between the main form and the subform is lngConsumerID. However the subform is opening blank. I tried requerying the main form in the After_Update of the txtConsumerID, but it’s still blank.

I use the same Order form witht the data entry switch off to edit existing orders. The address subform works just fine on it.

What am I missing?

E

Reply | Quote

Replies

You say that: “The link between the main form and the subform is lngConsumerID” but does this mean that you have explicitly set the master and child links between the forms?

Reply | Quote

You say that: “The link between the main form and the subform is lngConsumerID” but does this mean that you have explicitly set the master and child links between the forms?

Reply | Quote

Problem solved. At the point where I was requerying, the record had not yet been created. Set the requery to another control and all was well.

E

Reply | Quote

Problem solved. At the point where I was requerying, the record had not yet been created. Set the requery to another control and all was well.

E

Reply | Quote