RE: I can't believe I can't Figure this out.

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
--
Steve S
--------------------------------
"Veni, Vidi, Velcro"
(I came; I saw; I stuck around.)


"RonnieK via AccessMonster.com" wrote:

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:

select * from TABLE where FIELDID = forms!FORMNAME.LISTBOX

Hopt that helps.

Damian.

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

--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-gettingstarted/200610/1


.

Relevant Pages

  • Re: Opening a Report from a Filtered Form
    ... Create a query into the main Client table. ... Add the Attorney table to the query. ... Open the report in design view, and set its RecordSource property to this ...
    (microsoft.public.access.reports)
  • Re: initialize form
    ... and ClientID is the primary key of tblClients and a foreign ... then i'm guessing that the mainform's RecordSource is ... click ONCE on the subform to select it, then look at the Properties box and ... existing client record in the mainform, ...
    (microsoft.public.access.forms)
  • Re: SQL Code that is submitted to server changes when run on different clients
    ... > client, but when it is run on a different client the SQL code ... > I have an access ADP that in one of the reports, ... > run using SQL Profiler, I can see that when I run it on my PC, ... Did you try to use "SELECT * FROM dbo.yourUDF" as Recordsource ...
    (microsoft.public.access.adp.sqlserver)
  • Re: Combo box
    ... form's recordsource? ... It will be best if it's a query. ... Are you wanting to filter the form's data based on the two dates and the ... > from combo enter the dates so only the client picked from the combo box ...
    (microsoft.public.access.formscoding)
  • RE: I cant believe I cant Figure this out.
    ... I apparently can't figure out the syntax for this. ... My table name is "Client Master File" (Where the detail data comes from) ...
    (microsoft.public.access.gettingstarted)
Loading