Using a form to add new infromation to a data table for access 2013

[thracken]

Hello,

I have tried to use the form wizard make a form to input new information into my data sheet with old information that I need to keep and update with new information. How do i get the form to enter new information, if i can get it to add the first name and last name to the sheet then i should be able to get the rest of it fixed. The table below is somewhat like i need, if i don't have a last name it will not print anything. I am not sure how to write a lot of this that is why i was using the wizard. What field properties would i need to change and to what ? and be able to save it each time i enter new information ?

first name	last name	customer name	phone number
John	Doe	John Doe	111-222-3333
Tom			111-223-3333

[June7]

What is the 'old' data?

Should not have a field that combines name parts. Name parts should be in separate fields.

Don't really understand what the issue is. The wizard should have created a form bound to table and textboxes bound to fields. Type data into textboxes and it is saved directly to table.

[Demerit]

Welcome to the forum Thracken!

Just like June7 has said, Access does the majority of the job for you when you use the Form Wizard. Every control on the form is automatically bound to the table that was used to create the form. What you need is just to include an "OK" button on your form that saves the record and returns a blank form so you can continue adding data to your table.

[June7]

Can create an "OK" button with code to move to a new record row or use the intrinsic Access navigation features.

Is the form in Single, Continuous, or Datasheet view?

[thracken]

Can create an "OK" button with code to move to a new record row or use the intrinsic Access navigation features.

Is the form in Single, Continuous, or Datasheet view?

when i was using the wizard it would pull old information and it would not start a new record and it would save over the old information and pull the next line of old information.

the form is a single form that i will keep using to put "new" customers on the list and the list is an data sheet ( the data sheet has customer names, phone numbers, city, state, etc. oh and of course the "ID" field with the auto number as the key ) and all my information comes from 1 data sheet that i imported from excel

As for the names i watched a video and it showed me how to put first and last names into a new field together with a space between them, but if i did not have the last name it would not put any information in the full name field, but i dont have to use it i can just delete it.

the "OK" button sounds good i will try and see if i can get it to work

I think i answered the questions asked and I am new to access and it does have a lot of features i have to learn and thanks for your help

[June7]

The form is Single or Continuous or Datasheet or Split so not sure what you mean by 'the list is an data sheet'.

Access 2010/2013 has a field type Calculated which you might have been using and I misunderstood. Regardless, the calc should show first name even if last name not entered, and vice versa.

[Perceptus]

Does the bottom of the form have navigation controls on them? Check this page http://www.gcflearnfree.org/access2007/6.3 the navigation buttons should give you the ability to do what you need.

[thracken]

the form is single as it only does one record at a time then I have to start over with new information and I found the new file control on the bottom of the form to start a new record.

and with the names it dose not put both first and last name in it if one is blank, maybe i need to add " " ( a space to the settings ) so it will pick that up also

[June7]

Need space if don't want the name parts to run together.

[FirstName] & " " & [Last Name]

Should display name part(s) entered into record.

[thracken]

is there a way i can use [firstname]+" "+[lastname] and have last name used if it is just a space ( no last name )

[June7]

The issue is use of + for concatenation. Use & instead.

[thracken]

oh that worked out perfect !!! thanks a lot