Computing.Net > Forums > Database > Access Query to Form Question

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

Access Query to Form Question

Reply to Message Icon

Name: psonix
Date: June 6, 2006 at 08:18:50 Pacific
OS: Win Xp
CPU/Ram: Celeron D
Product: HP
Comment:

I am executing a query from the VBA using the docmd.openquery command. The same query is also the record source for the form I want to use.

When I call the open query command it opens up as a data table. How can I get it to sync up with the form and open into the textboxes?

I need to run the open query command to execute code in the vba that allows me to do multi keyword text searching.



Sponsored Link
Ads by Google

Response Number 1
Name: Jennifer SUMN
Date: June 21, 2006 at 16:25:25 Pacific
Reply:

I'm not sure if I understand what you're asking. Do you want to have a user open your form, which will then ask the user to input criteria and then the results (matching records) will show up in your Form View? Do I have that right?

Life is more painless for those who are brainless.


0
Reply to Message Icon

Related Posts

See More


MS Access Simple Database Saving SQL Database



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Database Forum Home


Sponsored links

Ads by Google


Results for: Access Query to Form Question

Access Query to Merge with Word Doc www.computing.net/answers/dbase/access-query-to-merge-with-word-doc/162.html

Access Query question www.computing.net/answers/dbase/access-query-question/606.html

Access Query Asks For Input Twice www.computing.net/answers/dbase/access-query-asks-for-input-twice/589.html