Where do I START ??

[AGM2004]

I am a newbie at Access2000 (although experienced with computers and some work with Excel) and need some help please.

I have "inherited" an Access document complete with tables, forms, reports, etc.

I want to pull ONE (and ONLY ONE) Record number (REC_NUM) populate the form/report with fields from this one table(names, addresses, etc to correspond to that ONE record). (I have already connected to a LARGE database via ODBC. )

How do I connect the query to a form or report? I need to pull JUST one record (by user input of record_number)--it wants to download the entire database each time??


PROBLEM: I can't seem to pull this into Access as I need to (I've done it in Excel, but need to expand to Access for more usefullness).

Thanks in advance for any help getting started...

 

[KenHigg]

See 'RecordSource Property' and 'Apply Filter' in Access help.

kh

 

[ReAn]

try putting this in the Record Source propery:


SELECT * FROM {myTableName} WHERE {myFieldName} Like [Please Enter The Record Number:]

Now, you only need to replace {myTableName} with the name of the table that you wish to grab from, and {myFieldName} with the name of the field that the ID is stored in.

DO NOT change the [] unless you wish to change the words in the popup.

When you open the form, it'll prompt the user for a record number, then get the information and display it how you wish.

 

[AGM2004]

Thanks to you both for your help...I'll give them a try!