Unbound forms

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to add a chart to a report based on a query. I cannot get the
information to appear on the chart and when I try to link the chart to the
report, I get the message "cannot link unbound forms". Why can't I link the
chart to the report?
 
What does any of this have to do with your subject line "Unbound forms"?
Does your report have a Record Source?
How are you attempting to link? Are you trying to use the link master/child
properties?
 
I asked 4 questions and you answered 1. If you still need some help, please
provide some details.
 
The record source is a query and when I try to use the link master/child
properties, the message I get is "cannot link unbound forms".
 
The record source is a query and when I try to use the link master/child
properties, the message I get is "cannot link unbound forms".
Click to expand...

IT seems you have two forms (only a Subform COntrol has link
master/child properties).

What is the Recordsource property of the mainform? Post the SQL if it
is a Query.

WHat is the Recordsource property of the subform? Post the SQL if it
is a Query.

John W. Vinson[MVP]
 
The main report is from the query. The chart is from the same query. Below
is the SQL:

SELECT DISTINCTROW tbl_How.How, Format$(tbl_Contacts.EnteredDate,'yyyy') AS
[EnteredDate By Year], Count(*) AS [Count Of tbl_Contacts]

FROM tbl_How INNER JOIN tbl_Contacts ON tbl_How.HowID = tbl_Contacts.HowID

GROUP BY tbl_How.How, Format$(tbl_Contacts.EnteredDate,'yyyy')

HAVING (((Format$([tbl_Contacts].[EnteredDate],'yyyy'))=[Enter year]));
 
2 suggestions:
1) you don't need to use the builder when setting the link master/child
properties.
2) don't use parameter prompt queries. Replace them with references to
controls on forms.

--
Duane Hookom
Microsoft Access MVP


Ronnie said:
The main report is from the query. The chart is from the same query. Below
is the SQL:

SELECT DISTINCTROW tbl_How.How, Format$(tbl_Contacts.EnteredDate,'yyyy') AS
[EnteredDate By Year], Count(*) AS [Count Of tbl_Contacts]

FROM tbl_How INNER JOIN tbl_Contacts ON tbl_How.HowID = tbl_Contacts.HowID

GROUP BY tbl_How.How, Format$(tbl_Contacts.EnteredDate,'yyyy')

HAVING (((Format$([tbl_Contacts].[EnteredDate],'yyyy'))=[Enter year]));


--
Ronnie


John Vinson said:
IT seems you have two forms (only a Subform COntrol has link
master/child properties).

What is the Recordsource property of the mainform? Post the SQL if it
is a Query.

WHat is the Recordsource property of the subform? Post the SQL if it
is a Query.

John W. Vinson[MVP]
Click to expand...
Click to expand...
 
wow that is hilarious buddy

yet another disclaimer

'dont use Access over a wireless network'
'dont use Access over a wireless WAN'
'if your access is buggy blame the network'

I'm just sick and tired of all the excuses / workarounds I hear

'dont use parameter prompt queries'

I mean seriously if your application DOESNT WORK then find a new
application.

MDB is buggy as hell
eat a cock sandwich, MDB wuss





Duane said:
2 suggestions:
1) you don't need to use the builder when setting the link master/child
properties.
2) don't use parameter prompt queries. Replace them with references to
controls on forms.

--
Duane Hookom
Microsoft Access MVP


Ronnie said:
The main report is from the query. The chart is from the same query. Below
is the SQL:

SELECT DISTINCTROW tbl_How.How, Format$(tbl_Contacts.EnteredDate,'yyyy') AS
[EnteredDate By Year], Count(*) AS [Count Of tbl_Contacts]

FROM tbl_How INNER JOIN tbl_Contacts ON tbl_How.HowID = tbl_Contacts.HowID

GROUP BY tbl_How.How, Format$(tbl_Contacts.EnteredDate,'yyyy')

HAVING (((Format$([tbl_Contacts].[EnteredDate],'yyyy'))=[Enter year]));


--
Ronnie


John Vinson said:
On Sun, 26 Nov 2006 15:55:01 -0800, Ronnie

The record source is a query and when I try to use the link master/child
properties, the message I get is "cannot link unbound forms".

IT seems you have two forms (only a Subform COntrol has link
master/child properties).

What is the Recordsource property of the mainform? Post the SQL if it
is a Query.

WHat is the Recordsource property of the subform? Post the SQL if it
is a Query.

John W. Vinson[MVP]
Click to expand...
Click to expand...
Click to expand...
 
Back
Top