display blank form for use as search form

[Stang02GT]

for the life of my i can not remember how to do this...

A co-worker asked me that when he makes a form based off of a table when he opens the form there is data from the table showing on the form. He would like the form to be blank when it is opened ( he wants no data to appear) because this it is a search form.

lol someone please refresh my memory on this


thank you in advance!

[missinglinq]

This should do it!

Private Sub Form_Load()
  DoCmd.GoToRecord , , acNewRec
End Sub

Linq ;0)>

[Stang02GT]

Isn't there something in the properties i can change....


Here is a better example of what he wants to do...


He has a form he uses to search the database with, one of his feilds is Description

When the form is opened, there is already text in the description box ( it is the 1st record of the description feild in the table that the form is based off of)

I thought there was a property for the text box on the form that you could set where the box will start out blank until someone searches for something.



hopefully i didn't confuse you :}

[BradHodge]

You can set the Data Entry property of the form to "Yes". This will bring the form up blank until searched.

Brad.

[Stang02GT]

You can set the Data Entry property of the form to "Yes". This will bring the form up blank until searched.

Brad.

Awsome thanks much!!!!!!!!!!!!!!!!!!!!!!!!!!1

[missinglinq]

If you set the Data Entry Property to Yes you'll get a blank record, but that's all you can do with the form, data entry! You'll get an error 3021, "No current record" when you try to retrieve a record!

[BradHodge]

Linq is definately right. I was able to get it to work on a form that was using Allen Browne's FindAsUType module, but that is a different set-up all together.

Brad.

[Scott Price]

Could be wrong here, so a few questions first. Is this a single form? Is he trying to look up the values with a text box?

If yes to both, try changing the text box to combo box (or creating a new one using the builtin wizards)...

Regards,
Scott

[missinglinq]

That's not the question, Scott. The question was how could he have a form with all the controls blank when the form first opens. Doesn't matter whether the search is done with a combobox (my preference) or a textbox and a command button, Data Entry set to Yes won't work! It won't allow an existing record to be retrieved into the form.

Linq ;0)>

[Scott Price]

Sorry, Linq. I wasn't thinking of the Data Entry setting. I agree that if it's set to Yes, it won't allow record retrieval.

I was meaning that for his search control, a combo box doesn't show any initial value when the form is opened. That doesn't really address the issue either, as you pointed out, of not showing any records at all on the form.

Regards,
Scott

[MMcCarthy]

The only way to do this is to have the form unbound when opened and set the record source after the search parameters have been entered.

However, to be honest I don't think the same form should be used as the search form. Create a form to enter the search parameters and then open the form to this particular record.

[Stang02GT]

Thank you guys for all your help!! We accomplished what he was looking to do, with your help of course :)

[missinglinq]

Glad we all could help!

Linq ;0)>