finding a new record

[sixaland]

Hi

I apologise if this is really basic - I am learning as i go along. I have designed a database. Most of the info is stored in the clientinfotbl. On the main form, I would have provided an option for users to search for a record based on its ID number and then pull up various forms accordingly. I am using the "find and replace" option to do this. My first question is, is there a better way? This feels a bit clunky!

Second question is, once I have entered a new record in the "newclientfrm" and go back to the mainfrm and search for that record, it cannot be found (once I have closed db and gone back in, it can then find it). Is there a way round this?

Any help would be hugely appreciated

 

[stepone]

Second question is, once I have entered a new record in the "newclientfrm" and go back to the mainfrm and search for that record, it cannot be found (once I have closed db and gone back in, it can then find it). Is there a way round this?

You need to do a me.refresh when you get back to the main form.

Hope that helps,
StepOne

 

[sixaland]

You need to do a me.refresh when you get back to the main form.

Hope that helps,
StepOne

To get it to do this automatically, do I put it in the "after update" event of the form? Thanks