Edit View Problem

R

Rob Roy CC

My form called "Jobs" has a Combo box that shows me my client list (from my
table "Clients"), I choose which client this job is for. The Client ID (PR)
is stored in my "Jobs" table but not the Client Name. When I open my "Jobs"
form in add view I see the Client Name but in "Edit" view I see just the ID.
I need to see the client Name instead. how do I do this. Thanks for your
help, in advance.
 
R

Rob Roy CC

Added info, sorry. I use 2 forms based from the same table "Jobs". When I add
jobs I use my form "New Jobs" and when I edit them I use "Edit Jobs". In the
"New Jobs" form the field is a Combo Box, in the "Edit Jobs" form it is a
Text box and is unchangeable. Thanks, Rob
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Where clause 4
Help needed with form and Combo box 1
How can I add an extra name to a drop down list ? 2
Combo box list based on information entered in another combo box 2
Using Linked Combo Boxes with a subform 1
Design Of Database 10
Record Duplicating Itself 9
Running 2 reports in a form together 3

Top