Thread: Creating a Form
View Single Post
  #12  
Old August 4th, 2009, 05:51 PM posted to microsoft.public.access.tablesdbdesign
BruceM[_4_]
external usenet poster
 
Posts: 558
Default Creating a Form

You won't help your cause by sniping at others. You can post your own
suggestion if you think the exchange is missing the mark, but you aren't
going to make yourself look bigger by trying to dig a hole under somebody
else. Quite the contrary: you are the one on his knees clawing at the
dirt.

"Steve" wrote in message
m...
Hello Damian,

You've been at this and you're not getting good help!!

Base your form on TblCrew. Use a combobox for the field cCrewTypeID. With
your form in design view, select the combobox. Open properties and go to
the Data tab. Set the rowsource property to TblCrewType. Still under the
Data tab, set the Bound Column property to 1. Go to the Format tab. Set
Column Count to 2 and Column Width to 0;2. Close properties.

Open your form and try your combobox. It should display ctType but will
save ctCrewTypeID for the selected crew type.

Steve


"Damian" wrote in message
...
Can't figure out how to do something.
I have two tables:

TblCrew
cCrewID PK Auto#)
cFName
cLName
cCrewTypeID Numberlinked to TblCrewType

TblCrewType
ctCrewTypeID PK Auto #)
ctType text

When I create a Form Using cFName, cLName and cCrewTypeID HOW can I make
the
box for cCrewTypeID display whats in ctType?

cCrewTypeID is an auto Number and is assigned to each ctType BUT on a
form I
dont want to see 1 or 5 I would like to see the type/text behind it like
Carpenter.

I tried look up combo box and I can see the ctType but when I select it
nothing happens since cCrewTypeID is set to accept only numbers and not
text.

How can I go around that?
Thank You.