Displaying name

[Kivan]

Hi,



I have a split form with data sheet on the bottom, and hidden single form. This form contains people who are assigned to the particular project, so in data sheet I see the people and in headline I should see the name of the project. I've created a textbox in the headline and its source is [ProjectName]. Ofcourse its not enabled and blocked, so you cant click on it.

The issue: When I open the form I need to click on the record to display project name at the top. No problem so far because I can create on load event with set focus on 1st record. The problem appears when there are no records, so I cant go to 1st record and the name is not displayed. Any idea how to deal with it?

Thank you for your time.

[redbull]

If Nz(Forms("frmmainnew").txtLNMuid, "") <> "" Then
        oLnM.Document.all.Item("firstResponder").Value = Forms("frmmainnew").txtLNMuid.Value
End If

This is something I used to determine if a text box is blank... It could possibly be manipulated into your situation.

If Nz(Forms("YourForm").YourTextbox, "") <> "" Then
oh wait a min

Question, what is the outcome you are looking for? If there are no records on load, what should the textbox say?

What is your form name? and txtbox name?

----

What I am thinking, if there are not records and you are creating a new one, do you want the text box to display "New Record"?

[Kivan]

Sorry, I have solved it by myself. Looks like brainlag after the weekend. I had to set value in "Default value" field as variable taken from another form, not in source field. My mistake sorry again.

I marked this as solved, but it should be deleted, thanks.