Show no record on open

  • Thread starter Thread starter Donna Brooks
  • Start date Start date
D

Donna Brooks

At this point when I open my startup form, which is used
to view employee information, the first record shows and
if possible I would like for it to be blank, until I
choose a record from the combo box. It's probably just a
simple property change. Could someone please help me out?
I have one more question. I have a text box that I
actually create as a combo box and changed it to a text
box. I am using it to type in an employee number and it
display the corresponding record, but right now our
employee numbers are only up to 790. If you type in any
number that doesn't have a corresponding record, it goes
to the first or next record. How do I fix this?

Thanks,
Donna Brooks
 
At this point when I open my startup form, which is used
to view employee information, the first record shows and
if possible I would like for it to be blank, until I
choose a record from the combo box. It's probably just a
simple property change. Could someone please help me out?
Click to expand...

In design view, set its Data Entry property to Yes.
I have one more question. I have a text box that I
actually create as a combo box and changed it to a text
box. I am using it to type in an employee number and it
display the corresponding record, but right now our
employee numbers are only up to 790. If you type in any
number that doesn't have a corresponding record, it goes
to the first or next record. How do I fix this?
Click to expand...

As a combobox you could have limited the list to whatever is in its
RowSource, e.g. the number of employees. You can't write a validation to
<=790, because you will exclude new employees. I suppose you could count the
records in the employee table and set the validation to that, but why use a
sledgehammer... Why do you not want a combobox?

Tom.
 
Back
Top