Thanks, Anna, for your prompt response. Sorry if I appear dumb, but this is my first VBA day although I have two year’s experience in designing in Access 2000 the conventional way (tables, queries etc). I tried the code below incorporating your suggestion and it locked on the very first line. I want to get values (integers) from fields M1-M12 in Table “tB” and display them in TextBoxes “Jan – Dec”on a form. What is wrong with my code, please?
Unfortunately, all the books I’ve seen do not make it very clear which are reserved commands and which are just names. Also, do you need to Dim a value if the value type has already been declared in a table?
I need to bill monthly on within X period and within Y budget. Later I will do calculations on them with quite a bit of logic and itineration (carrying balances forward) and lots of date manipulation. THEN I need to get data OFF the Module and onto other tables or queries maybe.
By the way, the reason why I am plunged suddenly into VBA is that every time I try to do a lot of itineration combined with logic statements in a query I get the error “Query is too complex” (Error #3360) I’ve posted questions about this but never got a response. I’ve given up trying to use queries for this section of the database.
I wrote:-
Option Compare Database
Private Sub Form_Load()
Dim CurrentDb.TableDefs("tb").Fields("M1").Value as integer ‘January Input
Dim CurrentDb.TableDefs("tb").Fields("M2").Value as integer ‘February Input
Repeat until Field M12 incl.
For fc = 1 To 12
M(fc)= TextBox M(fc)
Next M(lc)
End Sub
