Search button

[toffer67]

Hi guys,

As a few of you know (rural guy in particular) i have created a database and form to input the data into.

Now, when im using a search button i have created on the form it is finding the record but also seems to be deleting the record.

is there any way of just finding the record without replacing it???

any speedy help on This is critical now as i should have been rolling this out this week.

Thanks

 

[namliam]

You mean when you change a record you want to keep the old one too??

If that is what you are looking for, this is not supported by default by access. Have a search for "Audit trail" and see how to fix it.

If you mean something else, please clarify

 

[toffer67]

You mean when you change a record you want to keep the old one too??

If that is what you are looking for, this is not supported by default by access. Have a search for "Audit trail" and see how to fix it.

If you mean something else, please clarify

No, when i search for a record it shows on my form, but when i search again it has dissapeared from my database??

 

[namliam]

That doesnt automagicaly happen...

Are you per chance searching for the "Next" value? If there is only one of what you search, then yes it will say "not found"

 

[toffer67]

That doesnt automagicaly happen...

Are you per chance searching for the "Next" value? If there is only one of what you search, then yes it will say "not found"

So how do you search for the same record again??

 

[namliam]

Dont use "find next" but just use Find

Why search for the same record again? You allready have it on screen right?

 

[toffer67]

Dont use "find next" but just use Find

Why search for the same record again? You allready have it on screen right?

The same record may need to be shown more than once at different times.

I think i am sorted, i am using the new blank record button at the bottom of the screen before searching again and it is finding the record.

Thanks for your help

 

[georgedwilkinson]

Confusion. Are you clearing the search before searching again? That definitely causes problems.

 

[toffer67]

Confusion. Are you clearing the search before searching again? That definitely causes problems.

haud the bus, how else can i search, if i dont clear the other record that i have found then how can i add other records into the form??

What problems do you mean??

 

[georgedwilkinson]

I'm not following you.

You right click in a field, type a filter criteria into the "Filter" box and then do stuff.

Later, you want to filter again...do you clear the previous filter before you filter again? Or am I totally off base?

 

[toffer67]

I'm not following you.

You right click in a field, type a filter criteria into the "Filter" box and then do stuff.

Later, you want to filter again...do you clear the previous filter before you filter again? Or am I totally off base?

Yeah totally off base, i have a form with name, number date etc...

i have a search button, click the search button and search for a number, the number is found and added to the form with a name date etc..

i want to search again but need to clear the data in the form when i previously manually cleared the data it was lost, now when i use the clear field button its all good.

 

[georgedwilkinson]

Sorry, I totally misunderstood you.