Main form navigation button

[laura reid]

Hello,

I would call myself an intermediate level user of access, but have no coding
skill. I'm using Access 2003.

I'm having issues using the built in navigation selectors that are found at
the bottom of the main form. I have to click the navigation button the same
number of times as there are records appearing in my subform, when my intent
is to only have to click the navigation button once to move to the next main
form record, regardless of how many records are in the subform. I suspect
this has to do with my parent/child relationships, but I don't know why?

My database is similar to a checkbook, just more detailed. I have a
relational database with one to many join using primary/foreign ID key
fields. The transactions description and amout fields are on the many side
and the information assigning who the transaction belongs to, transaction
types, and account numbers, are in separate tables on the one side.

I then created a master query that pulls all the fields from all the tables
and I create and save queries off this base query depending on the info I
want.

I have a Main form based off a query that groups and sums information.
Essentially it tells me the office, transaction type, and account code, and
then the subform lists all the relevant transactions. The subform is based
off a query that does not sum or group the information.

I have the two forms linked through 4 fields in the parent/child properties.

Everything else on the form works fine...I'm able to enter new records in
the subform and these correctly save to the table that holds the transaction
and amount fields, along with all the linked fields accurately assiging the
transaction to the fields that show up in the main table.

So, any ideas?

Laura

 

[Allan Murphy]

Laura

If you have to cycle through the records it appears that the navigation
button is for your sub-form.

Do you have navigation button for your sub-form AND a navigation button for
your main form?

 

[laura reid]

Hello Allan,

Yes I do have navigation button on both forms. The form property is set to
'yes' to show the buttons. The subform navigation works, just not the main
form. If the curser is on a field in the main form and the navigation button
is hit, the main form record will not advance until it cycles throughthe
number of records on the subform, but the cursor never moves. Although both
forms are based on separate queries, both queries are based off the same BASE
query...could this be where my problem is. Should i have the subform and
mainform based off two separate tables that are linked with ID key fields? I
could try this, but then my problem is I need my main form to be populated
fields from 3 different tables, guess I could do that though with a query.
Hmmmm, ok, I think I'm on to something...nope that won't work, those three
tables are not related to each other, only the main table that stores all the
transactions.

 

[laura reid]

Ugh...so dumb....the db was doing exactly what it was told to do. I had left
the transaction description field on the query in the mainform thus it was
not grouping correctly. All is fixed now. One last thing to troubleshoot,
but I'll repost as a separate subject.

Thanks
Laura