Newbie Struggling

[Dave]

Hi

I am struggling with this on although I guess it is quite a common problem!

I have a table that I have normalised. I have a column called StaffID which
is the primary Key and then two fields one called FName and one called SName
which are the first and surname respectively.

I have a query which will give me StaffID and Fullname which as the name
suggests is the FName and SName combined.

The problem I have is when I come to put a combo box on a form. I want to
list the fullnames as per the query but when I come to save it I want to
save the StaffID number however it saves the Fullname.

I have tried this on a standalone database where the FullName is actually a
separate field in the table and I used the table rather than the query and
it seems to store the StaffID without any problem

Any ideas??

Thanks

 

[Rick Brandt]

Hi

I am struggling with this on although I guess it is quite a common
problem!
I have a table that I have normalised. I have a column called
StaffID which is the primary Key and then two fields one called FName
and one called SName which are the first and surname respectively.

I have a query which will give me StaffID and Fullname which as the
name suggests is the FName and SName combined.

The problem I have is when I come to put a combo box on a form. I
want to list the fullnames as per the query but when I come to save
it I want to save the StaffID number however it saves the Fullname.

I have tried this on a standalone database where the FullName is
actually a separate field in the table and I used the table rather
than the query and it seems to store the StaffID without any problem

Any ideas??

StaffID must be included as an additional column in your ComboBox (can be hidden
by using column width of zero) and then you set the bound column property of the
ComboBox to the column containing the StaffID.