Look-Up method

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

Guest

Hi folks,

Generally speaking there are alot of times where one needs the end user to
be able to scroll or drop down thru a selection of a key field in order to
choose the record they need to read. For instance if they do not know the
exact spelling of a name or the exact wording of title they can scroll down
to whatever is closest and then select which ever they want - and be
presented all the detail of that record.

In Report mode - I don't really want them having to click thru pages and
pages of all the detailed record data. But I don't see this drop-down
approach allowing them to scroll thru a key field possible in Report mode -

I can do it via a List/Combo box in Form mode but I don't want them to edit
live data which a Form normally permits. In Form mode, if I turn off Allow
Edit to 'No' - which seems like the answer - however then one can no longer
select from the combo/list box - you can view it but the No Edit status
prevents one from selecting one...at least that is the behavior I am
experiencing on my XP machine

So am wondering how this common need is typically satisfied? I can write a
VB selection if need be but just wondering if vanilla Access offers this
common requirement built-in. I would imagine it is fairly often needed out
there.

thanks for input
 
Well, your analysis is correct:
- You cannot seek in a report.
- Setting a form's AllowEdits to No disables the unbound controls as well.

The solution is to use a form, and set the Locked property of the bound
controls to Yes, so the user cannot edit them.

You should not need any VBA code unless you want to toggle the Locked
property of the bound controls on/off so the user can switch to editing
them. If that's the issue, see:
Locking bound controls on a form and subforms
at:
http://allenbrowne.com/ser-56.html
 
Back
Top