Field Look up

[RyanB]

Hi,

I have a data access page, aswell as a form where I want users to be able to put in a reference number into a field (this field is the primary key) and for it to either when a button is clicked or 'afterupdate' to load that record and have all the below fields bring up there information from that record.

If anyone can help me it would be much appreciated

Ryan.

 

[smercer]

Make a query (called "qry_lookup_Record") and have all fields of the table in the query.
In the form that you want to display only one record change the record source to the query name above above.

create a new form (called "frm_lookup_Record_Popup")

then in the form properties for "frm_lookup_Record_Popup" change the following:
Popup: "yes"
Modal: "Yes"
Border: "Dialog"
Navigation buttons: "No"
Record Selecters: "No"
Min Max buttons: "None"
Close button: "No"
Dividing lines: "No"
Scroll bars: "Neither"

Then click on the "Restore" button of the form (Not on the database window on the title bar the one directly below in between the minimise and the "X" window close button) then resize to the size that you what it for the user.


then put in the buttons and the text box (called "txt_Find_Record") in the "frm_lookup_Record_Popup" form. make sure the OK and Cancel buttons will close the "frm_lookup_Record_Popup" form.

make the button in the form that you want to filter one record, to open "frm_lookup_Record_Popup" form.

while "frm_lookup_Record_Popup" is open and in design view, in the query under the primary key, right click the criteria cell and choose "Build". in the expression builder double click on forms, then on "frm_lookup_Record_Popup", in the list box in the middle of the dialog you will find the name of your text box "txt_Find_Record" double click on this. then click on "OK"

Does this help? Please respond

 

[RyanB]

Many thanks for your reply, this helps me quite a bit, was wondering tho if this is at all possible on a Data Access Page as they are what I am mainly using as to avoid having all users purchase MS Access licenses.

Cheers,

Ryan

 

[smercer]

Many thanks for your reply, this helps me quite a bit, was wondering tho if this is at all possible on a Data Access Page as they are what I am mainly using as to avoid having all users purchase MS Access licenses.

Cheers,

Ryan

this is a bit out of my line, But I know it can be done using java script and access server or something.

It is very technical.

 

[RyanB]

Thanks again for replying.

This does not sound like good news as i'm not all that technical.

If anyone else has any ideas about how I can go about this please let me know as this is one of only 2 issues that are holding me back from rolling out the database.

Cheer,

Ryan