Search results

Sorry, the heading should be "Open Form to New Record in Sub-form"

I have a two table relational (1 to many) database. Parent Table (tbl_Employee) and child table (tbl_transfer) are joined by EmployeeID. I created a form/subform where the Record Source is a parameter query. The parent/child table displays the current records appropriately which I've set to...

okay, so this is why you guys are the geniuses! Thank you ever so much! problem solved, as you indicated my sub-form was ridiculously too large for what I needed. you can't imagine how long I spent researching that stupid (on my part) issue. And I also learned about anchoring. Thank you...

When I open the form, the main form with 5 fields are displayed on top. When I tab to the subform below, that entire subform moves up and hides the main form. when I try to expand the main form my clicking on it, nothing happens. I can only see the subform (and it's fields) and the main form...

I'm currently a beginner/intermediate Access databaser without SQL proficiency. Currently, I have a 1 to many database. Table 1 (main) - Employee info. Table 2 - Transfer info. I set up a form (employee info main form) with a sub-form (transfer info). My frustration is, when I tab into...