Combo box shows blank on opening the Form

[Alex Motilal]

Hi everybody
I have created a Main Form with a Subform. The Main Form contains a Client Combo Box, which on selection, the related records open in the Subform. My problem is:
1.When the form is opened, a Message Box appears, stating ‘No current record’. On clicking OK, the Form opens. I don’t want this Message Box to show.
2.When the Form opens, the Combo Box is blank, but the Subform shows records. However, on clicking a client, the relative records open in the Subform. The blank Combo confuses the users. Is there a way to make the Combo Box show the client, whose records are shown in the Subform? Or is it possible that the Subform is also blank?

Thanks in advance

[llkhoutx]

What is displayed in the presumably related subform depends on what is displayed on the related mainform.

If the mainform is positioned to the correct record on the Form_Open event, the subform will position correctly.

[RuralGuy]

Alex,
What code is generating the "No current record" message? Do you have something in the OnOpen or OnLoad or Current event of the MainForm?

[llkhoutx]

It could be a form/subform with a non undatable recordset as the row source with criteria that produces no results.

[RuralGuy]

I don't think that is the case here. Something is going on behind the form that the OP has not explained yet.

[Alex Motilal]

Dear RuralGuy
There is no code OnOpen or OnLoad or Current event of the MainForm
Alex

[RuralGuy]

Try importing everything into a new, empty db and see if you still have the same issue. If you do, can you attach your zipped up db so we can look at it?

[llkhoutx]

Look at the form event properties, calls to the following subroutines are created automatically (you have to prvide code within same):

private sub Form_Current()

end sub

private sub Form_Load()

end sub

private sub Form_Open(Cancel As Integer)

end sub