Macro to create new record from combo and text boxes

[daniel1676]

Using access 2003

What I want to do

Have a macro (button) to create a new record (save) from information the user enters and selects from a text box and two combo boxs.

What I have

The table that a want this record to save to is called Estimates. The text box (InputCustomerID) and the two combo boxes (EstimateTime and EstimateDate) are present in a Form (created in design view)

What I have tried

I have only done very basic macros (close one form open another) so I dont have any idea on how to do this. When i have tried to do this in the past i used the GotoRecord but this always ended in an error. I know that this is a big problem and not all that clear but any help would be good

 

[daniel1676]

I have tried to make my own (just focusing on time then copy for CustomerId and EstimateDate)

What the Macro Does

OpenTable --Opens the Estimate table
GoToRecord -- Adds new record
SetValue -- Item = [1001077_ESTIMATES]![ESTIMATETIME]
------------Expression = [Forms]![Estimates Form]![Combo39]

Error which follows
The object doesn't contain the Automation object 'Estimates'
You tried to run a Visual Basic procedure to set a property or method for an object. However, the component doesn't make the property or method available for Automation operations