Linking Information from Table to Form

[MTSPEER]

Hi I created a table with fields: ID Number, Member Name, Phone Number, Address, Contact Person, Reason for Referral, Referral Source, Date, Phone:, and Fax:. All the fields are blank. except for the Phone: and Fax: fields, those have numbers in them. How do I get those two fields to go onto every new form I create? And I want to add a combobox to the form, so every new record created they have that option. But I want every record created to be unique. For example, if i choose Sally for the combobox in the first record. The second record I want to pick Jim. and I want that information to be saved on each record. And for it to record the information back to my table. I hope I explained this enough.

-Mark

[RuralGuy]

Review the solution in this thread: https://www.accessforums.net/forms/a...ord-35364.html

[MTSPEER]

I am new to Access and all of that. How do I bound something? And isn't that to keep the combobox the same for every record? I want mine to be able to have different answers for each. I just want the two fields in my table to be the same on every record in the form.

[RuralGuy]

It has to do with setting the Default Value.

[MTSPEER]

With that code, will it save onto the table what I put into the form? And it will save what I put in the combobox for each record?

BTW-the two fields that I want to stay the same Phone:, and Fax: arent in comboboxes

[RuralGuy]

Have you tried it yet? The process I the same for TextBoxes.