Hi guys
Just a quick questions guys, I want to populate a textbox (txtA) in a subform with an increment of numbers starting from "1".
2 concerns; I don't want txtA to be filled in the unless other textboxes are filled in (can I make the code sorta like a dependant to these textboxes ?). Second concern, I have existing data on the table that is link to the same subform.
So the baseline here is if there is no prior record under the same ID, txtA would get a "1" in it else if there is a prior record (say "2"), txtA would have to be 3 and so on.
I apologise firsthand for being such a n00b on Access. I have no prior knowledge of coding VB. I would really appreciate any help/hints given.
mCool
Just a quick questions guys, I want to populate a textbox (txtA) in a subform with an increment of numbers starting from "1".
2 concerns; I don't want txtA to be filled in the unless other textboxes are filled in (can I make the code sorta like a dependant to these textboxes ?). Second concern, I have existing data on the table that is link to the same subform.
So the baseline here is if there is no prior record under the same ID, txtA would get a "1" in it else if there is a prior record (say "2"), txtA would have to be 3 and so on.
I apologise firsthand for being such a n00b on Access. I have no prior knowledge of coding VB. I would really appreciate any help/hints given.
mCool