Jump To Next Cost Code in Form

  • Thread starter Thread starter swichman
  • Start date Start date
S

swichman

I tried this before but was not successful. Hopefully I can explain
the problem a little more. I have a costs form tied directly to a
costs table with several line items with unique record identifiers
(recordid) per individual cost code. The costs table has several
fields (recordid and costcode among them). I am trying to develop some
code that I can put behind a button on the form to Jump to a record
based on the next cost code found in the table (finding the next cost
code in the table and jumping to the first record listed within that
cost code).
Hope this makes sense.
Any help would be appreciated.
 
I don't really understand your issue but if you base your form on a query
rather than a table then you can control the order the records are presented
in the RecordSet.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

VBA Excel - Select a value from one cell in Excel to update a SQL table 1
Separate Form 0
Total cost stored in a field 2
Help with a Form based off of a Table 1
Add Records Sequentially with DMAX 2
Tabs/Cursor Control 1
Update multiple record values from form/query 1
Form comes out blank with no fields to enter data 2

Back
Top