Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Continuous form form header issues

Status
Not open for further replies.

cruz610

Programmer
Jun 18, 2004
18
US
I have several fixed controls in the form header part of a continuous form. The problem is when I am entering values into a new section in the continuous form, the values in the fixed controls disappear. They reappear if i go to something that has already been entered in the continuous form. This is very wierd, its more of a quirk than anything I have noticed, but it would be nice to know if there is a way to fix it! Thanks:)
 
Do you have the fixed control's data control source equal to a control in the continuous form? If so, each time you're on that control in a new record, the fixed control will be blank. The following example has Text6 as a fixed control - it will show the current container from the form, but if I'm on a new record or one with a blank container then the control will still show the last value.

Example:
Text6 = fixed, value of current record container control

Private Sub header_bc_GotFocus()
If IsNull(Me.Container) Then
Exit Sub
Else
Me.Text6 = Me.Container
End If

End Sub

If this doesn't help, please give me an example of what you're looking for & I'll try to help you out.
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top