How to Make the Form Load display blank fields and not the first rec in DB

[ballj_35]

When my form loads, it display the first record on the DB. Then I go into the Combo Box and get the data I want. How can I make the Form_Load and Form_Activate display a blank screen and then when I select a record from teh Combo Box, then the data gets displayed to the screen.


Thanx in advance.

[Missinglinq]

This bit of code should do it, assuming that the Form is not Read-Only:

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

Linq ;0)>

[ballj_35]

Works great, Thank You very much! I have the following question now though. How come the following code does not work,

cboBondSelect.Value = "<Please Select>"

I have this code in the Form_Load and Form_Activate. Yet, when I load the form, the message does not display in my Combo Box. Thanx
in advance.

Jerry

[Missinglinq]

No idea, sorry! Works fine for me!

Do you get an error message?

What is the RowSource Type for the Combobox?

What is the RowSource for the Combobox?

And, of course, double-check that cboBondSelect is the actual spelling of the Control.

Linq ;0)>

[ballj_35]

It works fine on one of the forms, but not on the other two. They all have unique combo box names. To address your question,
The RowsSourceType is Table/Query and the RowSource is a Select statement to get the data from the table to select me member
to edit/view.

[Missinglinq]

I'm guessing that the Form it works on does not use a Select Query to populate its Combobox, which is why it works on that Form.

But when you use a Select Query like this, to populate a Combobox, I believe the Value has to actually be part of the Query in order for your assignment of a Value (i.e. <Please Select>) to work.

You can include it by using a Union Select Statement, using the general syntax

SELECT YourField FROM YourTable
UNION SELECT "<Please Select>" FROM YourTable;

Linq ;0)>