not finding newly saved data for some reason

[ChampionDuy]

I have a form where a user enters in two entities of a record which together make up the primary key for a record in a table. The user is promted to enter in new values and if the user enters in values that already exist then they get a error message saying that the record already exists. Which is good. However, when I type in a new value then click save. It saves like it should, but when I re type that same value again and try to save it again it does not give me the error message saying that the record already exists. But, if I close that form and then return to the form and then re type that same information it does find the data and gives me the correct error message. How can I get that error message to come up all the time? Any help would be greatly appreciated.

 

[David R]

Is it using combo boxes? You may need to Refresh the record source after each entry to make sure the combo is up to date and has the latest data.

 

[ChampionDuy]

No its not using combo boxes, the user enters in the data in text boxes.

 

[RV]

If your form is based on a query, try adding Me.Requery directly after saving the new row.

RV

 

[Pat Hartman]

What is the code in the click event of the Save button?

 

[ChampionDuy]

I was able to figure it out, thanks for all your help though, it is greatly appreciated.