OK, Clobber Me For A Noob, But...

[ckirmser]

I'm having a problem wrapping my noggin around a probably very simple problem.

I have a form for entering data on performance reviews. But, I don't want a new record for every entry.

So, I figure I would do a query on the Employee # that would;

1. Populate common fields on the form - and thereby the table - with data from the Employee table like Name and Position,
   
2. Search for an existing record in the Performance table and, if found, populate the required fields on the form,
   
3. If no existing Performance record is found, start a new one.

This is probably very simple and the answer is hiding under my "in" stack and laughing at me....

 

[rainman89]

What if u used a combo box on the form that with the "find the record on my form" option, that way if something exists it will bring u to that record and if it isnt there you just add a new record?

 

[ckirmser]

What if u used a combo box on the form that with the "find the record on my form" option, that way if something exists it will bring u to that record and if it isnt there you just add a new record?

I thought of that, and might have to go that route, but I was hoping for something like using the OnChange Event of the text box where the Emp No. is entered. I was thinking of something along the lines of a dynamic search that would populate the fields as soon as the Emp No. was entered or start a new record if no match existed.