Required help on Lookup fields

[johnc2806]

HI all,

I am looking for some help on a lookup field. Basically I have a field on a form that is referencing another field, which is all good and it pulls the data through. The only thing is that it does not update the table that the form is built from and I am not sure how to go about having it do this.

So field is this [Employee No].[Column](1). I thought I could do setvalue when I hit save record button, but it just comes up with automation error.

Any help would be appreciated as I have a few fields that have simple lookups in them, which do not store to the table.

Thanks

 

[johnc2806]

Any help would be appreciated?

 

[CJ_London]

people are probably not responding because you have not provided much information.

Please clarify terminology - 'lookup field' refers to a type of field in a table, comboboxes or listboxes are used on forms.

What is the code you are actually using and where?

what field (or control?) are you trying to update and why?

 

[johnc2806]

Sorry not that great with access and basically self teaching.

I have a blank table, which I have created a form from.(basically data entry) and saved the records. I have a combo box with a query from a separate table which holds staff information, which is pulling the employee no, name, and dept. This field you just select the employee no and the other fields, name and dept auto complete by using the a lookup to this field, which I do by just typing in =[Employee No].[Column](1).

It works fine, but the two fields, name and Dept do not update the table. Which is where I am stuck as I don't know how to get the info that is populated in the fields to save in the record on the table?

Hope that makes sense, sorry

 

[CJ_London]

more detail on your blank table? like what fields you have

and why do you need to store the data again if you already have it somewhere else?

What you would normally do is have a table with

employeeno
other fields

and in your form, your employeeno field will be bound to a combobox with the rowsource as you've described.

So the only field you wound be updating in respect of employees is the employeeno