I'm sure this is pretty simple but I can' seem to get it to work. Here's what I have....
Main Form is where the data entry occurs. really can't be used to search records
Form 1 - is a variation of Main form but is queried to return only certain criteria. IE... only pull records that are missing data.
Form 2 - allows searches of all records in the database.
Currently when I open a form they stay open, so they are not refreshing. So would it be better to somehow have each form close when I change forms or somehow do an event with requery? There are many fields that have to be updated from either just making a change to a record or adding a new record once all three forms are open.....
Any thoughts?
Main Form is where the data entry occurs. really can't be used to search records
Form 1 - is a variation of Main form but is queried to return only certain criteria. IE... only pull records that are missing data.
Form 2 - allows searches of all records in the database.
Currently when I open a form they stay open, so they are not refreshing. So would it be better to somehow have each form close when I change forms or somehow do an event with requery? There are many fields that have to be updated from either just making a change to a record or adding a new record once all three forms are open.....
Any thoughts?