Data in table being replaced / or changing

[Arvin]

Okay ...this is a wierd one .... for me anyways .........

I have a table that stores user information ... I have a form that is used to view the user info within that table ......

The form is setup so that when you select the "comapny name" it will autopop a few more feilds... the issue is ..

Lets say I select Company C .... the record under Company C replaces the Record under Company A within the table ..... thus deleting a record under Company A.....

Ummmm ....why ? .... btw ...I am a lil new to this ... so please forgive me if this doesn't make any sense : )

Thank you in advance

 

[Fozi]

Not sure I understand completely but should be a straightforward fix. Can you post the database andI'll have a look?

 

[Arvin]

Sure I can ....

The form in question is called ARVIN system customer Access

Thank you so much

 

[Fozi]

Your form is working perfectly!

The Customer Name pull down merely selects the Customer of choice and pulls forward their record.

No changes are made to the underlying table.

 

[Arvin]

Thank you Fozi ! ! !

I need stronger coffee then .....

I appreciate all your help! take care