Re: [MS_AccessPros] Combo Boxes - Multiple Questions Please

Thank you Gina!! So if I am understanding correctly, the only way to make a
"new" list item is buy having the table pop up and entering it there,
otherwise it will not stay permanently?

Thanks again!

Deb

On Sat, Jul 16, 2011 at 12:03 PM, Gina Whipp <classon@aol.com> wrote:

> Deb,
>
> For Scenario 1...
>
> Have a look at…
> http://www.dataschenk.com/newsletters/Tips/Access_Not_in_List.htm
>
> For Scenario 2...
>
> I think you want the name or ID to show up in a Text Box next to the Combo
> Box. If so, create an unbound Text Box and use...
>
> If numeric...
>
> =DLookup("FieldFromTableOrQuery", "YourTableOrQuery",
> "[FieldFromTableOrQuery]=" & Me![FieldFromForm])
>
> If text...
>
> =DLookup("FieldFromTableOrQuery", "YourTable", "[FieldFromTableOrQuery]='"
> & Me![FieldFromForm] & "'")
>
> AND you can also use the solution for Scenario 1 for Scenario 2.
>
> Thanks,
> Gina Whipp
> 2010 - 2011 Microsoft MVP (Access)
>
> www.regina-whipp.com
>
>

[Non-text portions of this message have been removed]

------------------------------------

Yahoo! Groups Links

<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/MS_Access_Professionals/

<*> Your email settings:
Individual Email | Traditional

<*> To change settings online go to:
http://groups.yahoo.com/group/MS_Access_Professionals/join
(Yahoo! ID required)

<*> To change settings via email:
MS_Access_Professionals-digest@yahoogroups.com
MS_Access_Professionals-fullfeatured@yahoogroups.com

<*> To unsubscribe from this group, send an email to:
MS_Access_Professionals-unsubscribe@yahoogroups.com

<*> Your use of Yahoo! Groups is subject to:
http://docs.yahoo.com/info/terms/