Repost for cell not visible

[Guest]

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb


Was this post helpful to you?
Reply Top





Barry Gilbert 9/14/2006 11:18 AM PST



Do you have the ColumnCount property set to 2 and the ColumnWidths set to
show both columns?

Barry

:

Click to show or hide original message or reply text.

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb

Was this post helpful to you?
Reply Top





babs 9/14/2006 12:43 PM PST



Yes, both items are as you say!! Can't figure this one out. Anyone have
any ideas.

Thanks,
Barb

:

Click to show or hide original message or reply text.

Do you have the ColumnCount property set to 2 and the ColumnWidths set to
show both columns?

Barry

Was this post helpful to you?
Reply Top





babs 9/14/2006 12:53 PM PST



The zone field worked okay until I added the following code to the cbozone
dropdown box. Need the cartage rate to go into the cartage rate field.

Private Sub cbozone_AfterUpdate()
[CartageRate] = Me![cbozone].Column(1)
End Sub

:

 

[Jeff Boyce]

Babs

Which column in your combo box is the "bound" column? Which of the columns
in your combo box's source is the first non-zero-width column (that's what's
being displayed).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb


Was this post helpful to you?
Reply Top





Barry Gilbert 9/14/2006 11:18 AM PST



Do you have the ColumnCount property set to 2 and the ColumnWidths set to
show both columns?

Barry

:

Click to show or hide original message or reply text.

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb

Was this post helpful to you?
Reply Top





babs 9/14/2006 12:43 PM PST



Yes, both items are as you say!! Can't figure this one out. Anyone have
any ideas.

Thanks,
Barb

:

Click to show or hide original message or reply text.

Do you have the ColumnCount property set to 2 and the ColumnWidths set to
show both columns?

Barry

Was this post helpful to you?
Reply Top





babs 9/14/2006 12:53 PM PST



The zone field worked okay until I added the following code to the cbozone
dropdown box. Need the cartage rate to go into the cartage rate field.

Private Sub cbozone_AfterUpdate()
[CartageRate] = Me![cbozone].Column(1)
End Sub

:

 

[Guest]

The "bound" column is zone and 1st one visible. Just realized when currently
in form and selecting the zone to get the rate - the what was selected in the
zone field shows up. However when close the form and reopen it the rate is
visible but the zone appears to be blank - not displaying the zone value on
the form but it shows up on the report.
Not sure what to do,
Barb

Babs

Which column in your combo box is the "bound" column? Which of the columns
in your combo box's source is the first non-zero-width column (that's what's
being displayed).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb


Was this post helpful to you?
Reply Top





Barry Gilbert 9/14/2006 11:18 AM PST



Do you have the ColumnCount property set to 2 and the ColumnWidths set to
show both columns?

Barry

:

Click to show or hide original message or reply text.

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb

Was this post helpful to you?
Reply Top





babs 9/14/2006 12:43 PM PST



Yes, both items are as you say!! Can't figure this one out. Anyone have
any ideas.

Thanks,
Barb

:

Click to show or hide original message or reply text.

Do you have the ColumnCount property set to 2 and the ColumnWidths set to
show both columns?

Barry

:

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set to yes
for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb

Was this post helpful to you?
Reply Top





babs 9/14/2006 12:53 PM PST



The zone field worked okay until I added the following code to the cbozone
dropdown box. Need the cartage rate to go into the cartage rate field.

Private Sub cbozone_AfterUpdate()
[CartageRate] = Me![cbozone].Column(1)
End Sub

:

 

[Jeff Boyce]

Please post the SQL statement of the combo box's Row Source.

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

The "bound" column is zone and 1st one visible. Just realized when currently
in form and selecting the zone to get the rate - the what was selected in the
zone field shows up. However when close the form and reopen it the rate is
visible but the zone appears to be blank - not displaying the zone value on
the form but it shows up on the report.
Not sure what to do,
Barb

Babs

Which column in your combo box is the "bound" column? Which of the columns
in your combo box's source is the first non-zero-width column (that's what's
being displayed).

--
Regards

Jeff Boyce
Microsoft Office/Access MVP


Microsoft IT Academy Program Mentor
http://microsoftitacademy.com/

Microsoft Registered Partner
https://partner.microsoft.com/

I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select the zone
the zone field is BLANK but the rate field is filled in. Visible set

to
yes

for the zone field. In the report the value for zone that was selected shows
up but is not visible on the FORM??????

Please help,
thanks,
Barb


Was this post helpful to you?
Reply Top





Barry Gilbert 9/14/2006 11:18 AM PST



Do you have the ColumnCount property set to 2 and the ColumnWidths

set
to

show both columns?

Barry

:

Click to show or hide original message or reply text.


I am selecting a zone in a combo dropdown list and after the zone is selected
the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is fine and
visible. The dropdown list for zone is visible but after I select

the
zone

the zone field is BLANK but the rate field is filled in. Visible set

to
yes

for the zone field. In the report the value for zone that was

selected
shows

up but is not visible on the FORM??????

Please help,
thanks,
Barb



Was this post helpful to you?
Reply Top





babs 9/14/2006 12:43 PM PST



Yes, both items are as you say!! Can't figure this one out. Anyone have
any ideas.

Thanks,
Barb

:

Click to show or hide original message or reply text.


Do you have the ColumnCount property set to 2 and the ColumnWidths

set
to

show both columns?

Barry

:

I am selecting a zone in a combo dropdown list and after the zone

is
selected

the 2nd column the rate is dumped into the rate field (in event
procedure-afterupdate of the cbozone field). The rate field is

fine
and

visible. The dropdown list for zone is visible but after I select

the
zone

the zone field is BLANK but the rate field is filled in. Visible

set
to yes

for the zone field. In the report the value for zone that was

selected
shows

up but is not visible on the FORM??????

Please help,
thanks,
Barb



Was this post helpful to you?
Reply Top





babs 9/14/2006 12:53 PM PST



The zone field worked okay until I added the following code to the cbozone
dropdown box. Need the cartage rate to go into the cartage rate field.

Private Sub cbozone_AfterUpdate()
[CartageRate] = Me![cbozone].Column(1)
End Sub

: