I am about to finish a project and I have a few items that are annoying on my form I cannot figure out how to fix:
1) Combo Box Default:
I have an unbounded combo box on a subform. This combo selects which record for that overall order the subform displays. The problem is that when I open the form I cannot get the batch "record" to default to 1 and also when it does open, the record it is dislpaying is not shown in the combo box, it is only blank. I have to select that record or another to get it to show the record number in the combo box. i tried to default it, that only puts a "1" in the combo, but dosen't actually set it to that record.
2) Combo box default on requery:
The same combo box mentioned above has another minor issue. If I select a different order (main form record) the combo box will go to the same number batch (subform record) that is was previously on, I.E. record 2 for parent record A to record 2 fro parent record B. When I select a new parent record in the main form I cannot figure out how to get the subform combo box to default back to the first record on parent record change. Parent record change is simply done through a requery.
3) Combo box requery:
Also when I change parent records on the main form it will show all the batches for the previous parent record and not the current record. I.E. record A has 5 bacthes and record B has 2 batches. When I change to record B it will still show I have 5 bacthes and when I select, 5 which dosen't exist, all fields show up blank because that batch dosent exist for that order. How do i requery the combo box values in a subform upon requery of a main form record?
4) Blank record:
I have multiple forms that have navigation buttons to advance to the next record. When I get to the last record an click next a blank record is always there, how do I get rid of that and only show valid records? I tried filtering the form and filtering the datasource query for the form, but the record still shows up. When I change the form to "snapshop" vs. dynaset it still shows up, but then I cannot edit/ enter data.
5) Looping record navigation:
When I am navigating records and I get to the last record (done through next macro buttons) and error pops up when I click next again. So I added to the macro to go back to the first record on error, it wors, but is kinda tacky. Is there any easy programming for a looping record navigator button?
Thanks for all the help, hammering out the minor details.