Creating a search function

[oraclejunior]

Hi all,

I want to create a search function in my database.

eg, Individual enters in a jobnumber and clicks search and the associated record is shown on a form (just to view only). How does one do this?

KR

Nick

 

[ZmrAbdulla]

Possible answers
[ul]
[li] ComboBox containing RowSource of the field (third option form the wizard) [/li]
[li] DLookUp Function[/li]
[li] Power Search Simply faq702-2039 [/li]
[li] Search multiple fields simultaneously and set form to record found faq702-1177 [/li]
[li] ................[/li]
[/ul]





________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.

 

[oraclejunior]

Using a combo:

Would that be the following: Set a combo for JobID (so that the user can only select the jobs in the system)

Set on after update event: refresh a subform that is based on a query using the job id.

Am I doing this correct?

 

[ZmrAbdulla]

No. somewhat near..
Make sure the wizard (wand) button pressed in on the ToolBar. Place a combobox on the form. Choose the third option from the wizard screen (Find a record....) Choose the field you want to search.. Access will create the code automatically.

That is all


________________________________________________________________________
Zameer Abdulla
Visit Me
Children are poor men's riches.