Re: non selectable table values
- From: "Rick B" <Anonymous>
- Date: Wed, 30 Mar 2005 15:40:51 -0600
If you are going to let them edit old records, then I can't think of a way
to lock them out of selecting certain entries in your combobox.
It can be done, but you would have to give us a way to decide which entries
were valid for each record. We could then try to come up with a validation
rule, a dynamic record source for the combobox, or vba code to do the trick.
You'll have to spell out the IFs that you use when you decide what is valid
for a given record. If you can tell us in English, someone (probably not
me) can most likely turn it into an sql statement that can be used as the
record source for your combobox, or vba code that will do the trick.
Map it out and see where it leads.
Rick B
"meilani" <meilani@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:CDDD6AED-6EDA-4381-8BD0-1FF3D1DD4959@xxxxxxxxxxxxxxxx
> 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
>
.
- Follow-Ups:
- Re: non selectable table values
- From: meilani
- Re: non selectable table values
- References:
- non selectable table values
- From: meilani
- Re: non selectable table values
- From: Rick B
- Re: non selectable table values
- From: meilani
- non selectable table values
- Prev by Date: Re: non selectable table values
- Next by Date: Re: non selectable table values
- Previous by thread: Re: non selectable table values
- Next by thread: Re: non selectable table values
- Index(es):
Relevant Pages
|
