update query depending on entry form used

[soulpiercing]

I have recently done an overhaul on my DB combining several tables into one then basing my forms off of Queries rather than tables (thanks for all the guidance on that issue).

Anyway - I am trying to find a way to set up my query filters to only show the portions of the main table relevent to the data entered in the relative form.

Is there a way to set up an invisible check box to default to checked once a record is entered in a certain form? Then I can base my queries off this box rather than data entry made by users.

Any help or suggestions welcomed - and again - thanks to everyone in the group.

Jason

 

[soulpiercing]

update on auto checking field to associate form

I got some answers in adding the field in the query and inserting the string:

me.fieldname = -1

into the before update property.

I am still having some trouble and now getting another error....

I posted the new .zip file of my DB after fixing a lot of issues.

Could you look at it if you get a chance and provide ANY input.

http://jag_clad.tripod.com/

or the file directly: http://jag_clad.tripod.com/clad.zip

Thanks

Everyone here on Access World is AMAZING.