StrikeEagleII
Technical User
I have a form that uses a stored procedure for its recordsource. When the form first opens I would like it to open to a new record, so I have it set up so when the form opens and gets it's recordset, it passes a parameter to the stored procedure that causes the stored procedure to return zero records. I am using ADO command/recordset objects and then Set Me.Recordset = rst where rst is the recordset returned from the stored procedure.
On the form header, I have several unbound controls used for a filter. The detail section of the form is where all the bound controls are. The problem is when the form opens, the detail is completely blank--none of the controls are displayed All the controls on the header show fine. If I select a value from one of the combo boxes in the form header, all the control appear as I expect (but there's no code that runs to do that...they just appear).
If I modify the parameters so that the stored procedure returns records when the form opens, all is well, but like I say, I want it open to a new record, so they can either enter a new record or filter to see an existing one.
I know that if your recordset has no records when the form opens and the form.AllowAdditions = False then everything will be blank (and this seems very similar to that), but my form.allowadditions = true. I've tried setting me.DataEntry = true, no dice. Any suggestions are appreciated.
On the form header, I have several unbound controls used for a filter. The detail section of the form is where all the bound controls are. The problem is when the form opens, the detail is completely blank--none of the controls are displayed All the controls on the header show fine. If I select a value from one of the combo boxes in the form header, all the control appear as I expect (but there's no code that runs to do that...they just appear).
If I modify the parameters so that the stored procedure returns records when the form opens, all is well, but like I say, I want it open to a new record, so they can either enter a new record or filter to see an existing one.
I know that if your recordset has no records when the form opens and the form.AllowAdditions = False then everything will be blank (and this seems very similar to that), but my form.allowadditions = true. I've tried setting me.DataEntry = true, no dice. Any suggestions are appreciated.