good day all.
i'm attempting my first database. ii have one table with a few drop downs from other tables. That being aid, the database will be used for error reporting.
what i would like to happen is this:
db opens to main form. analyst fills in info then hits button to take him to subform. subform info is entered and dollar amounts and numbers entered are totalled on the main for in 3 areas...
What's actually happening:
info is entered onto main form. when going to subform, it seems to be working fine but on the main form, the totals don't show up sometimes. what i'm seeing is that once info is entered on subform, it's jumping ahead to the next record.
I can't seem to figure out how to keep the form and subform on the same record...especially since they belong to the same table ...
i'm attempting my first database. ii have one table with a few drop downs from other tables. That being aid, the database will be used for error reporting.
what i would like to happen is this:
db opens to main form. analyst fills in info then hits button to take him to subform. subform info is entered and dollar amounts and numbers entered are totalled on the main for in 3 areas...
What's actually happening:
info is entered onto main form. when going to subform, it seems to be working fine but on the main form, the totals don't show up sometimes. what i'm seeing is that once info is entered on subform, it's jumping ahead to the next record.
I can't seem to figure out how to keep the form and subform on the same record...especially since they belong to the same table ...
