how can i do this?
i tried the onload event as below:
Private Sub Form_Current()
Me.Command2.Caption = Me.sbu

I keep getting an Error "Synatx Error In Query Expression"
Its this Line:
MyRate = "UPDATE JobsEmp SET [Rate] = " & Me.TxtNewRate & " " & _
If Me.TxtHidden = 0 Then

I am trying toget the enter key to function as a carriage return in a memo
box on a form.  I can get it to carriage return but then it returns to its
normal function,  is there an easy way to stop the enter key from resuming
its function after the carriage return is complete.

I have the following code on the dbl click event. It works great in another
database I created. However it returns a blank form when I use it in a new
database.
It should return the record with the matching DetailsID in frmEngLog. I only

In the application that I am developing there are records stored.  In some
cases a revision or change needs to be done to that record.  In this case I
want to keep a permanent copy of the old record as well as create a new one
with

I have a subform with two comboboxes.  One is dependent on the other
and the control sources for each are in the same table.
When scrolling through the records on the main form, the first combobox
always displays the option that was selected previously.  However the

I have a DB that is used to create Sales/Purchase Orders.  I currently print
the form (current page) and fax it to the relevant party.  But I would like
to be able to attach it to an email, or even convert it to an email so that
I can send it to them from Outlook.  Is this ...

Help,
I have a mainform where I have a text field called PartNumber, when I enter
data into it and hit the enter key I want it to add that data to the subform
where there is a text field also called PartNumber. This I have accomplished,

I'm trying to make a form in which the user enters a parameter to search a
table with.  The results would be displayed in a separate window.  I'm a
total novice at coding, so I really don't know what I'm doing.  I made a
combo box on my form, and the code is as follows;

I'm trying to figure out how to get information from a specific field
in a current form. What I need to do is retrieve this information, then
call an if/else based on it using a command button.  Any help would be
greatly appreciated.

i've done a bit of reading in this forum and concluded that using an
'OnChange' event to handle this is not advisable. what i read led me to
believe that the 'BeforeUpdate' update was the way. what i want to happen is
allow for any modifications to an 'On Study Date' field to ...

Is it possible to count the number of lines of text in a text box?
TIA
Tom

Is there a way to skip code, here is an example of what I mean:
Say you have a LastName field, and use Proper to convert smith to
Smith.  But, I want user to have option of using key combination or
whatever to be able to type in MacDonald and not have afterupdate code

For some odd reason my printview button on my form does not work, I get a
debug error telling me to check the macros...this is what I have for the code:
Private Sub Print_Preview_Click()
   Dim strWhere As String

I'm receiving a message when trying to run a Delete Query:  "Could not
delete from specified tables."
I can't determine what is causing the problem.  The help message indicates
that it is a security problem, but I don't see how.  Can someone give me