I'm in the process of putting together a database for work and I'm
running into a bit of trouble on one of my forms
I'm running the following code on an on click event procedure on a
form amongst other things

I have a text box in a form that is linked to a table field. I want
this text box to sum up 3 other text boxes, how do I do this, will it
save that result in the table? Thanks
ryan

I have a procedure that creates records in a bound form and then inserts
records to a related table. In the 'BeforeUpdate' event, I read the related
table to verify the existence of the required record, and if not existing,
display a msgbox.

I have a Multiple List Box with the following values that I pull from a query.
Asian
Asian/Domestic
Asian/European

I have a supposedly easy question but I am having trouble with the answer.
I have a sub form named "songsdetail" that has a button that opens the
"song" form so that I can add new songs to the song list.  This works great.  
When I return to the "songsdetail" form the new song ...

How to Detect and Prevent the Mouse Wheel from Scrolling Through Records in a
Form.
I donot want the records to scroll within the form. beside coding in VBA is
there any thing on form properties i can use and lock the scrolling of

strSql = " SELECT DISTINCT MyUnionQuery.MyField FROM MyUnionQuery WHERE " & _
   " MyUnionquery.MyCode Is Not Null " & _
   " and MyUnionQuery.[Activity Date] between " & _
   " [Forms]![frmmyform]![dtpStartDate] and

I have a problem with this code:
Private Sub Item_SKU_AfterUpdate()
...
...

I have a form that is frmsupplier in this form, I have two subforms
subformingredients and subformpackaging. In these two subforms a user
would input items of that supplier, but one form the
subformingredients would have only ingredients and the packaging only

I write this to a table in the current DB, I would also like to write this
to another DB that is not open nor linked.  The other DB is called
DataSafe.mdb  how would I do this?
Thanks

Sorry for the double post, I should have posted this thread here instead of
the general forum.
I have a user selection form with multiple combo box fields which are to make
a selection to build criteria for a report.

I have created a percentage crosstab query. How can I reduce, or get rid of,
the percentages?
cheers!

on a form with its data source: Notes, I have a command buttom with the
following code:
Private Sub cmdAddStandardProjectNotes_Click()
   Call DoSQLAddProjectNotes(Me) 'see code below

I would like to use a command button to delete a record. What is the syntax
to delete the current record?
Thanks,
Sam

For whatever reason this isn't UPDATING...
This gives me a 3144 Error
Dim UPSQL As String
DoCmd.SetWarnings False