[AccessD] Combo box Default Value

Bob Gajewski bob at renaissancesiding.com
Wed Apr 2 12:29:06 CST 2003


Mark

To ensure that only "unused" values are available, set your Table2,Field1 
to "Required=Yes, No Duplicates".

I am unclear on your second question ... when adding a new record to WHICH 
table? If TABLE2, are you saying that you want the next EXISTING value FROM 
TABLE1, FIELD1? Are these numeric values?

Regards,
Bob Gajewski


On Wednesday, April 02, 2003 11:49 AM, Mitsules, Mark 
[SMTP:mitsules_ms at nns.com] wrote:
> Group,
>
> My inability to succinctly state this question correlates to my 
inexperience
> with lookup fields.  I will name the objects in my description for my own
> sanity
>
> I have a table, (Table1) which has an autonumber PK, (Table1, Field0) and
> another field of values, (Table1, Field1).  I have a second table, 
(Table2)
> which has a lookup field (Table2, Field1) to both fields of Table1 but 
shows
> only Table1, Field1.  I have a form, (Form1) that is bound to Table2. 
 Form1
> contains a combo box control that, when clicked, shows a list of all v  
alues
> from Table1, Field1
>
> I would like to achieve two goals.  When adding a new record; To limit 
this
> list to values that have not already been utilized, and to show the next
> available value by default
>
> This seems like it would be a common situation, but I have never had the
> necessity before now.  Thanks for your suggestions
>
>
>
> Mark
> _______________________________________________
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> 



More information about the AccessD mailing list