Adding Records

[dedub]

This is probably an age old question but after a search I could not find the answer.
I have a table with 3 fields..... last, first, ssn
I have a form with 3 text boxes. I want users to input data into those text boxes and that data inserted into the table. The code I have figured out, the problem is access tells me I cannot add to the table because the controls do not have focus. Well, I can set focus to one control at a time but then that adds three separate entrees. Am I doing this the real hard way? Im sure there is an easier way to add records to a table with multiple fields.
Thanks

 

[Pat Hartman]

You are probably referring to the .text property of the controls. The .text property is only available when the ocntrol has focus.

In any event, if you use a bound form, you won't need any code at all to manage adding records to a table.

 

[dedub]

You are correct, I was going crazy with code when I should of just used the bound controls and used the wizards Add Record button. Like my title says.........

Thanks