Creating a search form

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

Guest

Hi all
First of all i probably am the biggest novice you will have. had no traingin
on access and learning myself.

Basically i am trying to creat a stock control database.

what i want to do is have a switchboard open up that asks me for a product
id (dress style number) and colour. once i fill these in it should dispay the
product form showing all the data. i have designed the product for with the
data. so all i need to do now is get this search form done.

Anyones help would be much apreciated

regards
Raveen
 
Raveen, might I suggest a nice simple way of achieving the same thing
without a search form?

- create a new ComboBox using the Wizard (Stars & Wand Button) from
the Toolbox and place it in the Parent Form's *header*
- choose the third wizard option on the first page which is "Find the
record in the form based on the selection I make in the combo box"
- when you are asked to specify the fields for the combo, only choose
those that you absolutely need to uniquely identify the selection. I
think in your case that is DressNumberID and Colour but you could add
a description form the field if it makes it easier for the user to
make the correct selection.
- do NOT accept the (Recommended) "Hide the Primary Key" In your case
the dress number is the Primary Key so you want to either type it in
or select it.
- finish the wizard.

When the form opens, from the combo box, you can do any of these to
find the correct record
- click the down arrow and scroll until you find it
- start typing and Access will auto-complete to the first match it can
find
- just type the whole number and press enter.

There are some refinements we can make once you have done this, but
we'll leave those until you have done this ... have fun

Cheers
Brett


Hi all
First of all i probably am the biggest novice you will have. had no traingin
on access and learning myself.

Basically i am trying to creat a stock control database.

what i want to do is have a switchboard open up that asks me for a product
id (dress style number) and colour. once i fill these in it should dispay the
product form showing all the data. i have designed the product for with the
data. so all i need to do now is get this search form done.

Anyones help would be much apreciated

regards
Raveen
Click to expand...

Cheers,
Brett
 
Back
Top