Find Record button on form (1 Viewer)

B

bmike

Guest
I have a form that runs off a subform and I am trying to set up a find record on the form. I need to be able to find a record anywhere with the data. Currently, I have the child/master fields on the form set for the record type I want and when I open the form it prompts me for a record, I enter the record data and it supplies it on the form. I enter the changes I need and then want to go to another record, so I have a command button on the form to find the record. But when I enter another record name in, I get an error that the record is not there. I know the record is there, I made sure it was while building the database that holds the form. How do I get the command button to find the record I'm looking for?
 

DES

Technoweenie
Local time
Today, 13:59
Joined
Apr 17, 2001
Messages
245
Sounds like when you enter the record the first time you are applying a filter. As a result the record source will not have the second record you are looking for. You simple need to remove the filter before opening the form for the second time.
 

Users who are viewing this thread

Top Bottom