AboutBob Heifler Expertise ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS - Free Access Tutorial Videos are available to you at my web site. Fifteen years of Microsoft Access experience allows me to answer most of your questions. Common question example files available here.
Experience
Experience in the area: Microsoft Access programming since 1994
Expert: Bob Heifler Date: 7/5/2008 Subject: MS Access Form - Where is the data source?
Question QUESTION: Good evening!
I have been staring at an MS Access 2003 Form and for the life of me cannot ascertain the data source for the form.
No tables are listed.
The form generates an output based on a single field of entry.
Regards,
Andrew Sefton
ANSWER: Andrew,
When you are viewing the form design, find the windows upper left corner square. Click on it and right click mouse to choose properties. Under all properties, it's the first property.
data source - record source
Bob
www.myaccessprogram.com
---------- FOLLOW-UP ----------
QUESTION: Bob,
Thank you for your response.
Through another process, I was able to determine that there is no data source. The form utilizes VBA code using CASE SELECT OnClick.
Going well beyond what I would think to be appropriate to question you, would you be able to direct me to a VBA resource that would assist me in changing the CASE SELECT to an IF..THEN..ELSE statement, that is, if button is selected and entry value is # amount, do this or this or this. All I can find on the Net is an "If button selected, echo X" which is not an ideal example for me to emulate.
Regards
Andrew Sefton
Answer Andrew,
I am not sure I am clear on all that you want. If you want one or two conditional logic branches the if then is fine otherwise the Select case allows for many more possibilities in an easy format. The select case can have a code like this:
Select case [TheAmtField]
Case > 5 and < 11
me.recordsource = "xyz"
Case > 10 and < 21
me.recordsource = "abc"
...
ALL MICROSOFT ACCESS DESIGN AND PROGRAMMING QUESTIONS -