Changing an unbound txtbox on continuous form

[ChronicFear]

Hi,

I created a continuous form that shows a a series of records in my database so the users can quickly scroll through and select the one they want. Each record is either keeping track of a business or an individual person. These names are stored in a table in three fields - the individual will be in two (FirstName and LastName) and the business is in (BizName). There is also a field called BusinessType, in which the user has selected if its a person or a business.

I'd like to have an unbound txtbox on my continuous form that populates depending on which type of entity is associated for the record. So something like

If Me.BusinessType = "Individual" Then
Me.Unboundtxt = Me.FirstName & Me.LastName
Else
Me.Unboundtxt = Me.BizName
End If

My problem I think is the fact that it is a continuous form. If I click on a field in the record, the txtbox will populate correctly. However, if no specific record is clicked, the code doesn't seem to run and the txtbox is blank.

Any thoughts?

Thanks,
CF

 

[pbaldy]

Try this instead, as the control source:

=IIf(BusinessType = "Individual", FirstName & LastName, BizName)

You might want to add a space between the first and last names.

 

[ChronicFear]

Worked like a charm! Thanks!