Combo Box Issue

aball65

Registered User.
Local time
Yesterday, 21:22
Joined
Oct 14, 2004
Messages
44
When I select a value from my combo box to support updating a field in an existing database row, all is well. However, when I select a value from my combo box to support creating a field in new record, nothing happens. The field on the form doesn't reflect the selected combo box item. Any ideas?
 
>>>>>>The field on the form doesn't reflect the selected combo box item<<<<<

the combo box should be linked to the underlying data, it should not have any relationship to any other fields on the form. What relationship does the combo box have to the field on the form?

Can you post a copy of your DB ?
 
List Box Issue

I have attached the database. To summarize, the database consists of:

3 Tables
======
tv_stations (tv stations)
dtv_prtcls (digital tv protocolos)
tv_stations_dtv_prtcls (M to M tv stations/digital tv protocols relationship)

1 Form and 1 Subform
================
form: protocols by station 3 (tv stations and associated dtv protocols)
subform: link protocol station (contents of tv_stations_dtv_prtcls table)

Thanks.
 
Attachment too big

The zipped up database file is 128K which exceeds the 100K maximum for attachments so I'll try to describe it here.

The combo box is in the subform and consists of two columns:
1. dtv_prtcl_id
2. dtv_prtcl_name

When I open the form, "tv station 1" is displayed in the form and tv station 1's dtv_prtcl_id, dtv_prtcl_name (1, protocol 1) are displayed in the subform. I can edit "tv station 1"'s dtv_prtcl_id and dtv_prtcl_name (e.g., update it to 2, protocol 2) using the combo box in the subform. However, I can't associate an additonal dtv_prtcl_id/dtv_prctl_name to tv station 1. When I select an additional dtv_prtcls_id/dtv_prtcl_name (e.g., 2, protocol 2) from the subform list box, nothing happens. The dtv_prtcl_id and dtv_prtcl_name fields in the subform remain blank and the underlying jumper table (tv_stations_dtv_prtcls) is not updated. I hope this make sense!
 
sorry , I still don't understand!

Just a thought , is the subform set "AllowAdditions = false"?

If not, I need to see DB, please post cut down ver....
 
Can't get it below 100K

I can't cut it down anymore than I already have. Can I email it to you?
allow_additions = true.

Thanks
 
Ran the Compact Utility

I ran the compact utility and was able to get the zip file below 100K. I've attached it.

Thanks.
 

Attachments

I Fixed It

I'm not sure what I did but it works now. Thanks for your help and interest.
 

Users who are viewing this thread

Back
Top Bottom