This should be a simple solution

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm creating a contact management database from the sample in Access 2000. I
added a table for CallType with three current records (Phone, E-mail, Visit).
Then I added an unbound Combo Box to the Calls Form. My new field shows to
the right in the Form and you can drop it down and select the type of call it
was, but it fills in the type you select on all the other call records. I
can't make one be a phone call and the next one an e-mail. If I click on
e-mail in a new call record, it changes the whole list of calls to be
e-mails. I joined the new table (with a field called CallTypeID) to a field
with the same name in the Calls table with a simple join. In the properties
for the Combo Box, under Row Source, it says SELECT [CallType].[CallTypeID],
[CallType].[Call Type] FROM CallType;
Can you help me?
Thanks
Trish T
 
Trish T said:
I'm creating a contact management database from the sample in Access 2000. I
added a table for CallType with three current records (Phone, E-mail, Visit).
Then I added an unbound Combo Box to the Calls Form. My new field shows to
the right in the Form and you can drop it down and select the type of call it
was, but it fills in the type you select on all the other call records. I
can't make one be a phone call and the next one an e-mail. If I click on
e-mail in a new call record, it changes the whole list of calls to be
e-mails. I joined the new table (with a field called CallTypeID) to a field
with the same name in the Calls table with a simple join. In the properties
for the Combo Box, under Row Source, it says SELECT [CallType].[CallTypeID],
[CallType].[Call Type] FROM CallType;
Can you help me?
Thanks
Trish T
Click to expand...

If sounds like the form is in Datasheet view... What is entered in the
Control Source property for the combo box? If it is blank, you have an
unbound control that acts like you describe.

In design view, you can see that there is only one combo box - in datasheet
(or Continuous Forms view), the unbound control is repeated for every record.
Note that the data is not being saved in the table (because the control is
unbound).

HTH
 
Thanks, Steve. Even though you didn't tell me exactly what to do to fix it
(just what was wrong with it), I was able to figure it out. I set the
Control Source for the combo box to CallTypeID and it works fine. Thanks!!
Trish T

SteveS said:
Trish T said:
I'm creating a contact management database from the sample in Access 2000. I
added a table for CallType with three current records (Phone, E-mail, Visit).
Then I added an unbound Combo Box to the Calls Form. My new field shows to
the right in the Form and you can drop it down and select the type of call it
was, but it fills in the type you select on all the other call records. I
can't make one be a phone call and the next one an e-mail. If I click on
e-mail in a new call record, it changes the whole list of calls to be
e-mails. I joined the new table (with a field called CallTypeID) to a field
with the same name in the Calls table with a simple join. In the properties
for the Combo Box, under Row Source, it says SELECT [CallType].[CallTypeID],
[CallType].[Call Type] FROM CallType;
Can you help me?
Thanks
Trish T
Click to expand...

If sounds like the form is in Datasheet view... What is entered in the
Control Source property for the combo box? If it is blank, you have an
unbound control that acts like you describe.

In design view, you can see that there is only one combo box - in datasheet
(or Continuous Forms view), the unbound control is repeated for every record.
Note that the data is not being saved in the table (because the control is
unbound).

HTH
Click to expand...
 
Back
Top