inner forms
The UK's Number 1 for Microsoft Office Training Add this page to your favourites/bookmarksBookmark page
 
View printable version of pagePrintable version
Plus One Google
Customer: Sign in
Delegate: Sign in
Trainer: Log in

Forum home » Delegate support and help forum » Microsoft Access Training and help » Inner forms

Inner forms

resolvedResolved · Low Priority · Version 2003

replyReply Fri 2 May 2008, 10:29Delegate Colin said...

Colin has attended:
Access Introduction course
Access Intermediate course
Access Advanced course
Access VBA course

Inner forms

I have a form with a combo box to filter results in the inner form that i have generated from an sql statement but i do not thing the sql is correct it works but it comes up with a box asking for the data that i thought would come from the combo box, can someone advise on the correct sql statement

For upcoming training course dates see: Pricing & availability

replyReply Fri 9 May 2008, 11:29Trainer Stephen said...

RE: inner forms

Hi Colin

It is difficult to specify your exact problem without seeing your code, although the fact that you are being prompted for a parameter suggests that a variable is being incorrectly defined

Could you please email me a copy of the code, along with an explanation of the tables involved

My email is stephenATmicrosofttrainingDOTnet

regards

Stephen

replyReply Wed 11 Jun 2008, 12:44Delegate Colin said...

RE: inner forms

Hi Stephen
Have sorted it now thanks

 

Please browse our web site to find out more about
access course london and other Microsoft training courses.

Access tip:

Display current date & time in column of any width

The worksheet function =NOW() returns the current date & time. When entered into a column which is not wide enough to display the value NOW returns, the cell displays ###

View all Access hints and tips


Microsoft Certified Partner Accredited Training Provider: Institute of IT Training Institute of Leadership and Management - Certified Courses Security Seal verified by visa, mastercard securecard