Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations Shaun E on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Adding Information via FORM

Status
Not open for further replies.

CatahoulaHound

Technical User
Feb 26, 2001
47
US
I have a very simple table that has 5 fields in it. 'FirstName' 'LastName' 'Phone#' 'Address' 'DOB' I now want to add another field 'CountyID' and use a form to add this new information to each name. I added the new field to the table and created a form based on that table. I added a combo box to lookup names and then added the information into the appropriate field, ‘CountyID’. As I am putting the information in the database is adding them to the overall record count like they are new records?? What am I doing wrong.
TIA for ANY help.
Pat
 
If your form is based on the table, and your able to scroll through the records (Set Navigation Buttons to Yes), then filling in that field should not add a new record.
If thats what you did, then the way you set up the Combo Box must be the source of your troubles.Try turning that back to a text box and see if that fixes it.
Need more info to help you more specifically though
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top