Recent content by RobertScott

Perhaps This may be close to what you are looking for

this is a pain in the butt... What you need to do is add a field for invoice number and make it an autonumber field. The problem with that is that it starts at 1. So you have to make a new (temporary) table with a field that has a value of 1000. Then make an append query that inserts that 1000...

try this I had a similar problem referencing controls on a subreport from a main report. I was trying to reference the control like this: =[Report]![ReportName]![ControlName] But I found that was incorrect and found out that it needed to be referenced this way instead...

wow That is a lot of subreports, I did a report like this recently. Every value under the month is retrieved through sub reports? I don't know how complicated it is for you to get those values but wouldn't it be easier in the long run to have one sub-report in your details section that...

Maybe something like this Maybe you can try something like this. Also, it is hard because I don't know how you have your record source set up or what your form looks like. Dim I As Byte inputloop: Text14.SetFocus If Text14 Like "DH*" Then txtPSSN = Text14...