Putting data into a table from a form

[Guest]

Hi

I started a simple form at the moment, FirstName, LastName, and CusID.

I'm using the CusID as my PrimaryKey.

The name of my fields are strFirstName, strLastName, and intID.

How do I get the information in these fields into the table that I called CustomerProfile.

Thanks to all for your help.

Cheers

Ren

 

[Marc]

Hi Ren,
In design view of the form there is a grey square on the top left corner of
the form. Click on this.
On the property table for the form (the hand on the form button if not
showing) the first field should be 'record source'. Click on the right
corner of the field part and you should get a drop down arrow. Select your
table name (CustomerProfile).
Highlight your field strFirstName (field not label).
On the property table for that field, under the name is the field control
source. Click on the right corner of the field part and you should get a
drop down arrow. Select the table field name that relates to the field ie
FirstName.

hth
Marc

 

[Guest]

Thanks very much Mark.

Cheers

Ren

Hi Ren,
In design view of the form there is a grey square on the top left corner of
the form. Click on this.
On the property table for the form (the hand on the form button if not
showing) the first field should be 'record source'. Click on the right
corner of the field part and you should get a drop down arrow. Select your
table name (CustomerProfile).
Highlight your field strFirstName (field not label).
On the property table for that field, under the name is the field control
source. Click on the right corner of the field part and you should get a
drop down arrow. Select the table field name that relates to the field ie
FirstName.

hth
Marc