'Object does not contain the automation field 1

[monkeysee]

I have a form that also contains a subform.
The main form is basic: name, address; city & zip. which is based on a query (ClientID; Name; Address; City & Zip)
The subform is to add transactions for the client. this subform is also based upon a query which as the following field: VisitID; ClientID, Visit date

The subfom is linked between the two ClientID fields: Clients.ClientID and Visit.ClientID

After entering infor for the Client in the main form and then going forward to add the visit information, an error pops up with: 'Object does not contain the automation field ClientID

I have used this concept in several other forms and other databases and never had this problem.

Any ideas what may be going on?

A Big thank you to everyone that helps us rookies out!

 

[MajP]

That error is usually due to the linkmaster and linkchild fields properties not being correct. Could be a typo in those property or the names not matching what is really in the queries. I would delete them out and reestablish the link. Make sure the names are correct to your table and query names.