Dear,
Forum
I am prompted to enter tblMaster1 in the parameter when I open rptMaster.
I cant figure out why is it happening.
Can somebody please help me?
Attachment 32031
TIA
Haziq
Dear,
Forum
I am prompted to enter tblMaster1 in the parameter when I open rptMaster.
I cant figure out why is it happening.
Can somebody please help me?
Attachment 32031
TIA
Haziq
Something weird with the CurrentQty textbox. I deleted it then created a new textbox and set its ControlSource. No more prompt.
How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.
You are creating Master1 when you simply need the query to link the two tables together as the record source for your report.
Also instead of prompting the User for the values in that report, use the form it is called from current record;Code:SELECT tblMaster1.MasterIDPK, tblMaster1.Subsystem, tblMaster1.Item, tblMaster1.Location, tblMaster1.CurrentQty FROM tblMaster1 WHERE (((tblMaster1.Subsystem)=forms!frmMaster!Subsystem) And ((tblMaster1.Location)=Forms!frmMaster!Location));
DLookup Syntax and others http://access.mvps.org/access/general/gen0018.htm
Please use the star below the post to say thanks if we have helped !
↓↓ It's down here ↓↓
Dear,
June7
[Qoute]Something weird with the CurrentQty textbox.[/Quote]
I set a faulty conditional formatting expression.
It has been solved in one of my threads.
Thanks for debugging it for me.
Much appreciated
I will need to change my code to hold 2 inputs maybe cascading.use Form to get parameters for report
I do not know how to change the code.
TIA
Haziq
(I promise I am trying)