Find

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Guys,

I'm designing a form for a database which has customer details stored. The
user searches for the customer record and adds to it, comments etc. What I
want to do is this.

Rather than using the Find function, which you can choose which field to
search on etc. I want to put a text box, in which she puts the account number
in, clicks a command button and it finds the record. Does that make sense? So
it's basically all on one form.
 
Wolfman said:
Guys,

I'm designing a form for a database which has customer details stored. The
user searches for the customer record and adds to it, comments etc. What I
want to do is this.

Rather than using the Find function, which you can choose which field to
search on etc. I want to put a text box, in which she puts the account number
in, clicks a command button and it finds the record. Does that make sense? So
it's basically all on one form.
Click to expand...

Drop a new ComboBox on the form with the ToolBox wizard enabled. One of the
wizard options for a ComboBox does exactly what you want. It should be the
third choice on the first page of the wizard.
 
Rick,

I don't see a third option on the first page. The Combo Box wizard gives
these 2 options:

"I want the Combo box to look up the values in a table or query"
and
"I will type in the values that I want"

Neither of those will do what I want it to do. I don't want a combo box
anyway. Maybe I didn't explain it well enough in the first message.

I want it to have a text box, which the user can enter the search criteria
into (Account Number) and then click a command button to find it. I want to
set it so it will only search the AccountNumber field for the number given.
Then display that record in the form itself so that the user can alter and
add to the existing record.

I've been looking at DoCmd.FindRecord but cannot get that to work. I need to
make it look at the contents of the textbox so that it can then find it.

Can any one help?

Regards,
Ash.
 
Dear Wolfman:

PMFJI, but your form needs to be bound to a table/query for the third option
to appear.

Perhaps you might expand more on *why* you don't want to use a combobox. You
certainly *could* use a textbox and command button to do what you want, but
setting up a combobox is much easier, and there are some real advantages to
using a combobox, including the ability to "Limit to List" and "Autoexpand".
I encourage you to give it a try; I bet you a virtual beer you'll like it
better! <g>


HTH
Fred Boer
 
Fred,

I owe you one Virtual Beer...

Cheers,
Ash.

Rick,

It was my bad in the first place, I blame it on it almost being the weekend...

Cheers,
Ash.
 
Back
Top