Form: 1st record showing before Combo Box selection

[DajTwo]

Hi all

Access 2003, front end / back end config.

The record is selected using a combo box in a form populated by a query.

All works well however is there a way to prevent the 1st record to show on the form when it opens before the user use the combo box to make it selection?

I hope this is clear..

Thanks

 

[KirbyWallace]

Not much to work with here in the way of details. It sounds like you have a bound form, and when it opens, you use a combo-box to make a selection, which then creates a filter, which is then applied to the form recordset.

Just my guess.

In this case, I'd say, no, there is no way to not make the first record show. If you open a bound form, it opens... bound....

Sounds like what you need to do is open a "record selection criteria" form FIRST. Get your selection, THEN open the bound form and apply the filter with the WHERE or FILTER args of the OpenForm command.

If I'm not reading you right, maybe try again...

 

[missinglinq]

Why not open the form to a new, blank record:

Private Sub Form_Load()
 DoCmd.GoToRecord , , acNewRec
End Sub

The Missinglinq

Richmond, Virginia

There's ALWAYS more than one way to skin a cat!

 

[DajTwo]

Good ideas to request the selection first the open the form.. Ill also try to open a new record on the form..

Good ideas!!! Thanks

 

[TheAceMan1]

How are ya DajTwo . . .

You can also use the forms [blue]Data Entry[/blue] property:
[ol][li]In for design view set the property to [blue]Yes[/blue].[/li]
[li] In the [blue]After Update[/blue] event of the combo, copy/paste the following:

[blue]   If Me.DataEntry Then Me.DataEntry = False[/blue]

[/li][/ol]
[blue]Your Thoughts? . . .[/blue]

See Ya! . . . . . .

Be sure to see thread181-473997 [blue]Worthy Reading![/blue]
Also faq181-2886 [blue]Worthy Reading![/blue]

 

[DajTwo]

Hi Aceman, Im well thanks..

I tried your suggestion and when the form opens all is blank, no labels or data.

 

[DajTwo]

Missinglinq,

Thanks for the suggestion, the form does not allow the user to add new records, only data on existing records. I could create a 000000 record that would always show 1st..

KirbyWallace,

You are right, I would have to create an 'entry form' with the combo box then open the data form when the user selects the record.

Thanks again for the ideas.. good to learn other ways of doing stuff.

happy holidays..