PLEASE HELP...deadline at work and stumped!

[dukenukem]

Hey guys...

I am pretty good with Excel VBA but not so much with Access VBA. I may not even need VBA for this but i basically have a Form that i have set up which needs to pull data from a query i have set up in Access. All the tables and the query are good to go..that is not the issue.

The issue is that i cant seem to be able to search a query for a loan ID then have all the fields in the Form i have set up populate with the appropriate data. I have figured out how to run the query with a command button based on an ID i enter that then pulls up the actual query results in a table view...but i dont want that. The user would not understand that view. I need the results to be pulled into the Form i have created. Do i need VBA for this or is there another way.. Thanks!!!
Have to have this done by monday so would appreciate any help!!!

Duke

[alansidman]

Make the record source for the form your query. With your form open in design view, click on properties, then Data and select your query for your record source. Filter as necessary.

[dukenukem]

Thanks Alan...

I have all the records I want to pull linked to the query liked you described above.

My issue is on the filter. When i type in the ID i want to search by do i need a command button to rerun the query each time i enter a new ID?

Right now in the query...I have in the ID field a criteria linking to the Form to only SELECT WHERE ID = ID in the form. I think that is what i need to do.

My problem is that in the Form the only thing i have figured out how to do is put a command button that runs the query based on the ID i enter and shows me the results in a table view...and not populating the fields in the form. I would like to run the query based on the ID i put in and not have the query results pop up in the table view...rather just populate the fields in my Form. Lemme know if that makes sense.

thanks again!

[orange]

Along with what Alan has provided, watch this free video tutorial on search
http://www.datapigtechnologies.com/f...earchform.html

[alansidman]

I think that you may wish to use a custom filter instead of a search form from what I gather from your posting. Look at this video on a custom search using the query as your record source.

http://www.datapigtechnologies.com/f...tomfilter.html