> This has to be very simple... but...
> I have a form that displays records in a list box based on a check box = Yes.
[quoted text clipped - 17 lines]
> Any help will be greatly appreciated.
> Ronnie Keith
Damian, Thanks
I apparently can't figure out the syntax for this.
My table name is "Client Master File" (Where the detail data comes from)
My list box form is "Processing - Select Clients". (This is the form that
contains the list box "Processing Client List").
My List Box Name (In the "Processing - Select Clients" Form) is "Processing
Client List" (This is the list box in the first form that I select the record
I want to use in the "Processing Detail" form).
The form that I'm trying to get the information to show in is "Processing
Detail"
ID is the primary key (auto number).
This is a "flat file" I'm only using one table for this.
Here's what it looks to me like I should enter into the "recordsource" for
the form "Processing Detail"
select * from Client Master File where ID = forms!Processing - Select Client.
Processing Client List
But I get errors.
Again, I really appreciate any help you can give me.
>Why not set the recordsource of the form you are opening to select records
>that match the item you selected in the listbox eg:
[quoted text clipped - 10 lines]
>> Any help will be greatly appreciated.
>> Ronnie Keith
SteveS - 31 Oct 2006 11:57 GMT
PMFJI,
The problem is that you used spaces and special characters when you named
your objects. As you have found, spaces in names of objects causes you
headaches.
Since you have spaces in the names, you need to enclose them in brackets:
Try this:
Sselect * from [Client Master File] Where [ID] = forms![Processing - Select
Client].
[Processing Client List]
If you must separate words, use the underscore Client_Master_File
This is another way (no spaces) >> ClientMasterFile
Also, search the web for "naming conventions". Here is one page:
http://www.mvps.org/access/general/gen0012.htm
A consistant nameing convention makes it easierto tell what the object is
if the object is then the prefix is
table ............ tbl
form..............frm
listbox............lb (lower case L )
So the recordsource would look like:
(should be one line)
Sselect * from tblClientMasterFile where [ID] =
forms!frmProcessingSelectClient.lbProcessingClientList
Just remember - if you use spaces in object names, enclose them in brackets :)
BTW, form "Processing - Select Clients" must bo open when you open form
"Processing Detail".
HTH

Signature
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)
> Damian, Thanks
>
[quoted text clipped - 39 lines]
> >> Any help will be greatly appreciated.
> >> Ronnie Keith