Re: non selectable table values

Tech-Archive recommends: Fix windows errors by optimizing your registry

Thanks Rick, those are great suggestions. However

(1) I don't think the validation rule would work in my case since the values
I need blocked are not all necessarily at the top of the list; meaning items
#1, 5, and 12 is what I want to prevent from being used.

I suppose I could change things around but that would be very tricky to do,
wouldn't it? Also, would this interfere with past record entries that used
these values?

For instance I have tbl_Main that is linked to tbl_Version. A txt_Code field
on my form (tbl_Main source) holds a generated value based on the Version
value (combo box) the user chose.

(2) You're 2nd suggestion wouldn't work b/c I DO need to be able to allow
edits to old records.

Maybe, I can't have it both ways...


"Rick B" wrote:

> I would probably use a validation rule to specify that the field cannot
> contain a value less than X.
>
> Or, change the query upon which that drop-down is based to only include
> current values. As long as they do not go into previous records and try to
> modify that field, they will not run into problems.
>
> Rick b

.

Relevant Pages

  • Re: non selectable table values
    ... don't think the validation rule will come into play. ... >> to lock them out of selecting certain entries in your combobox. ... >> Rick B ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Validation Rule
    ... Could you give some direction on how to create a required entry in the ... this like a validation rule that a message pops up? ... "Rick B" wrote: ... >> invoice number must have the user forced to key in the amount in the ...
    (microsoft.public.access.forms)
  • Re: non selectable table values
    ... may work afterall. ... For the validation rule, ... "Rick B" wrote: ... > rule, a dynamic record source for the combobox, or vba code to do the trick. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Controls on Forms
    ... Just set the validation rule to... ... Rick B ... advancing to the next record if one of the controls is ... Thanks fro any help ...
    (microsoft.public.access.formscoding)