L
Les
Hi,
I'm not great with forms, but since you haven't gotten
any help, I'll give it a shot. It seems like your problem
could be fixed if you had the client # assigned on the
main form (TblClientID) instead of the subform
(TblClientInfo).
Then, on the subform, in the before update event, you
can move the client # from the main form to the subform,
which will populate your TblClientInfo.
Something like this:
Me.[client id] = Forms![Main Form]![client id]
Hope this helps.
I'm not great with forms, but since you haven't gotten
any help, I'll give it a shot. It seems like your problem
could be fixed if you had the client # assigned on the
main form (TblClientID) instead of the subform
(TblClientInfo).
Then, on the subform, in the before update event, you
can move the client # from the main form to the subform,
which will populate your TblClientInfo.
Something like this:
Me.[client id] = Forms![Main Form]![client id]
Hope this helps.