Find in form

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

René - 12 Jan 2004 01:26 GMT

I have aphyscians combo box on my main client form. I placed a command button on the form that will open a physicians form to enter the proper info in case the doctor isn't already on the list

I entered a Dr. using this method and when I go to the form and use Ctrl F to pull him up it won't find, doesn't do much of anything really. I checked the table and he's there with the proper DoctorID and he is also correctly entered on the Client for

?????????

Reply to this Message

Duane Hookom - 12 Jan 2004 01:54 GMT

Your new record will not become part of an open form's recordset unless you
requery the open form. If you don't understand how to do this, you might
want to share your code that opens the physicians form.

Signature

Duane Hookom
MS Access MVP

> I have aphyscians combo box on my main client form. I placed a command button on the form that will open a physicians form to enter the proper info

in case the doctor isn't already on the list.

> I entered a Dr. using this method and when I go to the form and use Ctrl F to pull him up it won't find, doesn't do much of anything really. I checked

the table and he's there with the proper DoctorID and he is also correctly
entered on the Client form

> ?????????

Reply to this Message