Putting data into a table from a form

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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
 
Thanks very much Mark.

Cheers

Ren

Marc said:
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
Click to expand...
 
Back
Top