asked on

Multiple charts based on user's inputs on one form- Microsoft access

Hi,

I'd like to create charts based on selected listbox items & entered dates from a form.

The first graph works fine, but the second one isn't loading the correct data.

I think the problem is that the second table uses "ID" instead of "WorkerID" and the main form's record source

is based on a specific table.

I've tried to create relationships between tables tWorker,tReg and tAbsence, but it did not recognize WorkerID in tReg.

Is there a solution to this?

Thank you.
Charts_14-09-2018.accdb

Dale Fye

You should be able to use any field name in the lInkMaster and LinkChild properties of the subform (subReport). and you can actually point one of those values to an unbound control on your main form, if you need to. So instead of selecting a field on the main form as the Master, select the control that the value is in.

Dale

John Tsioumpris

I don't see any charts in the sample you uploaded.

David Lelièvre

ASKER

@Dale Fye

Thanks, I'll try something.

@John Tsioumpris

It is in the form "frmReg".
Charts.png

David Lelièvre

ASKER

Hi,

I've added the child/master link on the second charts, but I'm getting the error "The microsoft access database engine does not recognize 'qAbsence!ID' as a valid field or expression.

Why am I getting this error and how can I fix this?

Thank you.
Error.png
Modification.png
Charts_18-09-2018.accdb

This question needs an answer!

Become an EE member today

7 DAY FREE TRIAL

Members can start a 7-Day Free trial then enjoy unlimited access to the platform.

View membership options

Learn why we charge membership fees

We get it - no one likes a content blocker. Take one extra minute and find out why we block content.