Thanks Duane. I was storing box numbers in the Items table - a BIG no-no. I changed it so it's a lookup field to the box number table now and works great!
--- In MS_Access_Professionals@yahoogroups.com, Duane Hookom <duanehookom@...> wrote:
>
>
> John,Remembering suggests the listbox is not bound (doesn't have anything in its Control Source property). You use this typically for allowing users to select criteria for forms and/or reports. Storing is when you want the selected value to be stored in a field in the form's Record Source. Duane HookomMS Access MVP
> To: MS_Access_Professionals@yahoogroups.com
> From: jlinux@...
> Date: Fri, 30 Dec 2011 15:22:37 +0000
> Subject: [MS_AccessPros] Form Listbox
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> I am setting up a listbox on a form that is based on a Query. What's the difference between "Remember the Value for later use" and "Store the Value in this field"?
>
>
>
> Thanks,
>
> John
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
>
> [Non-text portions of this message have been removed]
>
Tidak ada komentar:
Posting Komentar