March 15th, 2003, 06:35 PM
|
|
Contributing User
|
|
Join Date: Feb 2003
Location: UK
Posts: 75
Time spent in forums: < 1 sec
Reputation Power: 6
|
|
|
Access form problems
I have a couple of problems with a form I created in Access 2002.
1st. I want to place a text box next to a combo box to show the full name of the empoyee.
I have looked in the control column in properties but only First Name and Surname are available, If I choose either only the one part displayes in the text box.
I also tried typing =[First Name]& " "&[Surname] in the control box but this gives me #Name?.
2nd. I have a combo box that shows a list of employee codes and also the surname. i want to change this to show both the first name and surname. I have tried adding the first name in the query builder with no luck, I also tried deleting the column referencing the surname and typing =[First Name]& " "&[Surname] in the empty cell. this gives me a box called enter parameter value, which is not what I want at all.
If anyone can offer some answers I would be grateful.
the form is called frmWarranty and the combo box is labeled checked by.
Charlie
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
