Novice
Windows 7 64bit 
Access 2013
I have used some basic macros, having trouble using the Openform one.
I want to be able to click on the PartID field in the tblOrders datasheet frmOrdersDS which would open that part "Part ID in the frmComponentEntry.. When I click on it at present the correct form opens but not at the correct part ID. I believe the issue could be the Where Condition.
VIP
Windows 7 64bit Access 2010 32bit
Need something to analyze.
Post code for analysis.
If you want to provide db, follow instructions at bottom of my post.
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.
Novice
Windows 7 64bit Access 2013
[PartID] = Forms![frmComponentEntry]![PartID]
VIP
Windows 7 64bit Access 2010 32bit
That certainly looks ok.
Next step is to provide db.
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.
Form/subforms from multiple tables- how to link fields properly?
Using JOIN to connect two tables then update common fields CAN'T EDIT HEADACHE
Posting Permissions
Reply With Quote