Hi,



I've just started using Access 2000, although I've used it as a database 

to link to ASP, I find it difficult to write SQL in Access (Even though 

I've used SQL in Oracle).



Anyway, could anyone point me in the right direction to find information 

on setting up a form which will allow a user to search for records based 

on input. ie. If the user inputs a name and presses return it should 

return the address etc.



Could anyone help? I don't mean to be such a dunce,



Thanks,

Michaela

I have done this by using a Combo box. My form was based on a table, 

then Using the Wizard I added a combo box and selected the option to 

have it look up a record according to the criteria selected.

Regards

Don

Michaela:



	If you turn on the control wizards and create a new Combo box it

will ask you what you wish to do with the combo box, one of those

options is Lookup records based on.... If you pick that its fairly easy

to make the combo box lookup records based on which field you bind the

combo box to.



For example the wizard will create a Combo box that will search all

records in tblCompanies where Company Name = (whatever user types in, or

selects from the combo list)



-----Original Message-----

From: Michaela [mailto:lanmbran@h...] 

Sent: Monday, October 15, 2001 9:53 AM

To: Access

Subject: [access] Beginning Access - need help on making forms please!





Hi,



I've just started using Access 2000, although I've used it as a database



to link to ASP, I find it difficult to write SQL in Access (Even though 

I've used SQL in Oracle).



Anyway, could anyone point me in the right direction to find information



on setting up a form which will allow a user to search for records based



on input. ie. If the user inputs a name and presses return it should 

return the address etc.



Could anyone help? I don't mean to be such a dunce,



Thanks,

Michaela



---

You are currently subscribed to access as: joe@s... To

unsubscribe send a blank email to $subst('Email.Unsub')

Thank you very much!! I've got it to work at last, now I've got some code 

to work with, I should be able to go behind the scenes to manipulate it.



(A very happy) Michaela