Recent content by Chocolatte

:) Thanks Exodus! I see what you're saying about the Quad field needing information. It's the answer I've been searching for! Thanks for getting to the bottom of this for me.

My DB is 25mb, so I've sent a greatly reduced version. This basically has the forms, tables, and queries associated with the main form and subform. If you try to add nest info. in the nest form and exit the form without entering observation info., then the added nest will not show up when you...

Pat & Exodus, Thanks for your suggestions. I have made the suggested changes, but I still can't get the added records to show up on the forms. I changed the join properties on the query which contains the nest table and observation table and the added records still don't show up in the query. Is...

The form is bound to a query which consists of the nest information table and observation table. Any thoughts on what I should look for when editing the relationship table? As it stands now, many observations can be entered for 1 nest. Thanks.

How did you get that to work? I want to be able to the current record. I used your code example and got the following error: Syntax error (missing operator) in query expression '([tblNestTree.NestTreeID]=EELR 22)' Here is a snippet of the code I used: stDocName = "rptOspreyInfo"...

I haven't been able to find a posting that lists the problem I'm having, so I'm hoping someone has some suggestions to offer. Background: I have a subform AddObs (child) that is linked to the main form AddNest(parent) by the NestTreeID field. I have it so that when someone fills in information...