And more to the point, what is the SQL of your Row Source query?
John Viescas, author
Microsoft Office Access 2010 Inside Out
Microsoft Office Access 2007 Inside Out
Building Microsoft Access Applications
Microsoft Office Access 2003 Inside Out
SQL Queries for Mere Mortals
http://www.viescas.com/
(Paris, France)
-------------------
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Liz Ravenwood
Sent: Friday, June 22, 2012 10:30 PM
To: 'MS_Access_Professionals@yahoogroups.com'
Subject: RE: [MS_AccessPros] Help! - Amendment to form
Is it a left join? right join? inner join?
Liz Ravenwood
Database Developer / Programmer
Super First Class Products
B/E Aerospace
O: 1.520.239.4808
www.beaerospace.com
-----Original Message-----
From: MS_Access_Professionals@yahoogroups.com
[mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of toukey1
Sent: Friday, June 22, 2012 1:25 PM
To: MS_Access_Professionals@yahoogroups.com
Subject: [MS_AccessPros] Help! - Amendment to form
Hi,
I am at the point where frustration is setting in as I cannot get this simple
thing to work.
I have a form that was working but now the user wants to include a new drop-down
field. No problem I thought. I then proceeded to create a new table which I have
called LossType and I have 3 fields which are:
seqno (auto number - primary key), loss_type (Text) and ins_type (Text).
ins_type is an existing field from another table as the user wants to be able
when entering data on the form, to only display the loss type for only that
particular ins_type.
I created a form based on the LossType table and entered the relevant info. I
then proceeded to my existing claim form to add the combobox for the loss_type.
I had to create a query based on the claim and loss type tables and did a join
on the loss_type fields.
The problem when I view the results in the query I am getting no data. When I
remove the join the data is duplicated.
Please help!
------------------------------------
Yahoo! Groups Links
This email (and all attachments) is for the sole use of the intended
recipient(s) and may contain privileged and/or proprietary information. Any
unauthorized review, use, disclosure or distribution is prohibited. If you are
not the intended recipient, please contact the sender by reply e-mail and
destroy all copies of the original message.
Tidak ada komentar:
Posting Komentar