Text field get value from combobox (1 Viewer)

[sajarac]

Hello, I was wondering if somebody could point me in the right direction?

I have 2 tables "customers" and "assessments"

I select the customer name from a combobox in the assessment form, and I have several fields that based on the customer the information is automatically populated.

the formula used is :
=[comboboxcustomer].[Column](1) for phone
=[comboboxcustomer].[Column](2) for name
=[comboboxcustomer].[Column](3) for title ....etc

it seems like is working, but after I close the database and open again I got in those field : #Name?

I do another combobox, can see the data again, close the database and then the same error.

Any idea?

thanks in advance

 

[sneuberg]

Does the problem clear up when you select an item in the combo box? Maybe you need to set the combo to a default value and requery it on form load.

 

[sajarac]

Thank you very much for your promp reply.
When I switch from record to record the issue persist

The only way to get the fields working is to start over then I can see the rest of the data,

Sorry I am not an expert, could you please provide me some assistance?

 

[sneuberg]

Could you upload your database?

 

[sajarac]

Hello, I have applied your suggestion and it works great!

Thank you very much for your help!

 

[sajarac]

Hello there, after a couple of tries, the issue continue, the problem is with a macro that I have to save data between record changes, enclosed is a screenshot of the macro, and the error that I am getting .

I have disabled the macro and after this I can see the information based on the combo box.

could you please let me know how I can resolve this?

 

[sneuberg]

I don't see anything in the code that would cause that error. Can you upload your database?

 

[sajarac]

Hello, and thanks again for your prompt reply, unfortunately I can't upload the file, it have some company information. sorry I am desperate with this issue, now I cannot save the data, once the macro is disabled I can see the #Name? data, but the save option is disabled.

 

[sneuberg]

Could you create a new database and import the malfunctioning parts with empty tables and upload that?

Sorry but there's no way I can figure out what's wrong with the information you have provided so far.