Re: dropdown list cbo to find record

Tech Tip: Click here to run a free scan for Windows Errors and optimize PC performance

Corrine and Tori,

oh, hey, I totally forgot about this...

for a form where you do not want to allow changes to the data, make the form RecordsetType --> Snapshot

that way, you do not have to deal with Locked or Enabled for the controls -- just leave them set to the defaults

you will be able to change anything that is not bound to the underlying RecordSource, such as a 'find combo'

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




strive4peace wrote:
Hi Corrine,

make sure that, for the combo:

Locked --> No (False)
Enabled --> Yes (True)

this is opposite of what it should be for your data controls

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Corrine wrote:
Now the dropdown won't open at all.

"strive4peace" wrote:

Hi Corrine,

"The dropdown list will open, but I cannot select anything from the > list. This form needs to be only for running searches, not for editing in any way."

My guess is that you have the form AllowEdits property set to False

If you want the user to be able to edit the search combo, instead do this:

for each control, set:
Locked = True
and. optionally,
Enabled = False

and set AllowEdits = True for the form

Warm Regards,
Crystal

remote programming and training

Access Basics
8-part free tutorial that covers essentials in Access
http://www.AccessMVP.com/strive4peace

*
(: have an awesome day :)
*




Corrine wrote:
I have a form with a dropdown list from which I want to be able to select an item and have the rest of the form populate additional fields with that record's information. Preferrably the form will start out blank. Currently it is automatically populating with the first record and is only letting me use the navigation buttons (at the bottom of my form) to move from record to record. The dropdown list will open, but I cannot select anything from the list. This form needs to be only for running searches, not for editing in any way. Suggestions? I'm working in Access '07.
.

Quantcast