Form, nothing special, contains a subform (showing a table without filter or whatever, simple query) and a textbox. I want to show the number of the current record that is 'selected' (shown by the black triangle) in the textbox.
Problem is, I dont know how to use the CurrentRecord-whateveritis in VBA.. If I set the source of the txt to =[frmkamernrs].[CurrentRecord], it just shows #name?, which apparently is not right.
The idea in the end is to show in a custommade form all the data contained in the table(s). But first: How do I 'detect' the current record in the subform? It can't be that difficult
Heh it gives an error, it doesnt understand the current-statement ... Maybe some access97 thing :s
Anyway, I AM getting somewhere, if I keep it in the same form, the =[currentrecord] works just fine, but when I add the subform, the record-pointer stays neatly at 1, nevermind what I'm doing in the parentform with the navigator-buttons... Apparently, theyre totally un-attached