Simplest way to run 2 queries invoked by a form?

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Here's the requirement.

User needs to be able to enter 2 items of data onto a form and press a
button. The code behind the button needs to check that both fields have
a valid entry (one is a pick list of values 1-3 the other is a date) and
then execute 2 SQL statements.

1) do i put the sql statements into individual queries?
2) presuming I use the "on click" method on the button, how would I code
references to the two fields on the orm?
3) within the sql, how do I refer to values of the two fields on the
form?

This is part of a voluntary project - not my area of expertise at all,
so appreciate some simple code examples or pointers to where I can get a
primer in how to do this elementary stuff with Access.

BTW it is Access 2003.

TIA

--

jeremy
.

Quantcast