ms access - Running a report showing current record from subform -
firstly, database using navigation form has tabs down side allow user navigate through forms , forms within have sub forms.
now issue have i'm trying run report using macro , condition shows current record. if view form on own (not through navigation form) button works (happy days) when use through navigation form (which how user using it) asks me enter id record first. technically report still run relies on user entering correct id.
this condition: [childid]=[forms]![frmmealchoice]![childid]
there way navigate subform in condition?
sorry if doesn't make sense can't think of better way of explaining it, appreciated.
as stated in comments figured out went instantly after posting question. interested here ammeded condition; [childid]=[forms]![frmmainnavigation]![navigationsubform]![childid]
Comments
Post a Comment