List box not "active"

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm certainly no expert in Access, but this has got me scratching my head...

I've got a form with a list box, used for locating the record I want to
view. The form's table is essentially a register of visitors. The list box
contains the unique visitor number, a surname and company name. I've used
list and combo boxes before in similar circumstances and they work fine - I
don't think I'm doing anything differently this time.

My problem is that when I first open the form I'm unable to select any
records by clicking on the values in the list box. Strangely, if I go into
form design mode, view the properties of the unbound list box, close it and
return to normal mode it then works...

Any ideas what I'm doing wrong and how to get it to select the records as
soon as I open the form?

Thanks in advance of any replies.

Mike
 
In case anyone's inyterested, I worked this out myself after further
head-scratching...

The command button I'd put on the main switchboard that launches my form had
it set to open as acReadOnly. So, even though I didn't want to edit any
fields on my form as such, I needed to set it as AcEdit so the list box could
do its' stuff. I've set all the fields I don't want to edit as locked and
not-enabled, as well as setting the form properties to not allow edits,
deletions etc.

I'm still not sure how simply displaying the properties of the list box
overcame this originally, but there you go...

Good luck,
Mike
 
Back
Top