Form Data (1 Viewer)

[GRM-kenyette]

I Have A Form With A Combobox When I Choose A Record Form The Box The Matching Info From The Table Populates A Textbox
Example
I Choose The Acct Number From The Box And The Company Name Goes In a Textbox
looks like it is fine on the form My Problem Is That When I Look At The Table The Company Name Is In Its Right Field But The Account Number Field Has The Companies Name Aswell
How Do I Fix This-
and also if you type the number in the acctnumber field on the table it places that number in the acctname textbox of the form there is something that is mixed here but i dont where
Thanks

 

[Uncle Gizmo]

Open the table in design view, Click on the row that represents the field you want to change, you will see a panel below with two tabs, "General" and "Lookup" Select the lookup tab and change the display control from combo box to text box.

 

[GRM-kenyette]

form

it is already a textbox

 

[Uncle Gizmo]

Are you looking at a table or a query?

 

[GRM-kenyette]

form

the table
after i complete a new record on the form the tables info is incorrect

 

[Uncle Gizmo]

Account Number Field Has The Companies Name Aswell
Thanks

What this tells me is that your table has a look-up against the account number field. So it displays two pieces of information. To do this It must also display a combo box. Changing the combo box to a text box will stop it display in two pieces of information.