I have the following code behind my cmdPreview button on a Form:
---------------------------------------------------------------
Private Sub cmdPreview_Click()
On Error GoTo ErrorPreview

I want to populate a field using date based off a state...ex.
if State = Texas, then [part a]![Sale date] or if state = Utah, then [Part
a]![r-c-r date] and so on
What is the best way to accomplish this..

I have a form with a button that I want the user to be able to click to run a
query.  I keep getting this error:
Run-time error '2342'
A RunSQL action requires an argument consisting of an SQL statement

I posted this question yesterday but didn't get a response that fixed the
problem.
i have a subform with navigation buttons (First, Previous, Next, Last) which
were created using the wizard so all the code is what Access gave me.  On the

My form has asks for the serial number a specifc part. I have another form
where all the serial numbers are inputed with the various measurements. How
can i retrieve the data i want from my table containing all the serial
numbers for use in a program in the first form that asks for ...

Apologies if this is a dumb question but I've been thrown in at the deep end
with Access/VBA and don't have a clear idea of the basics.  Most of the code
I have written so far has referred to objects in the same form as the macro
so I've been using Me.object. I'm a bit confused ...

On my main form, I'm trying to bind a field called "term_mos" to 2 option
buttons: 1) in months and 2) in weeks so that I can calculate an ending date.
I used the option group and boxed in the 2 option buttons, but it allows me
to select both.  My current code is:

I am trying to add some convenient additionals to my app.
On dblCklick on a certain text field some specific info gets added to my
memo field (description)
for now I have the descrition just added at the end....description =

Hello Again,
I would like to be able to double-click a record called "LastName" in a form
"Client Select" that's for viewing and have another form "Client Form" open
and display the record that was clicked.

On my subform I have my own navigation buttons (created using the command
button wizard).  Currently, my subform is set so that the Access nagivation
buttons are still visible (the buttons that say "Record: 1 of 6 (Filtered)",
etc). The mainform is filtered so that it shows all ...

I am trying to create a new record in a subform "subA" but I keep getting
the message "There is no field named 'SubA' in the current record".  Before
new records are added, the AllowAdditions property of both the main form and
subform are set to false.  So far, I haven't changed ...

I am trying to link notes created in a form called "Notes" to my data entry
screen called "Data Entry"
I have created a relationship with the ID of the Data Entry Form and the
Customer ID field in the Notes form.

I have a note tracking table that I want to be able to use for several
different forms (that are all accessing data from different tables).
So, when I create a new note record, I want to capture which form was active
when the note was created then stuff that name in a field called ...

I have a 2 Page Form with 2 Buttons in the Footer.  When I go to the
second page I want the frst button to hide and the second button to
appear.  When I go to the first page I want the reverse to happen but I
keep  getting this message.  How do I fix this?

Is it more advantagous to use SQL from a table to supply data to a control
on a form as in the sql statement below:
SELECT DISTINCT flkp1.Field1 FROM flkp1;
Or sql from a query as below: