RecordSource prperty as varable

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I develop a bookkeepingsystem for many In a menuform i choose the company
number. Based on that number i want to use the proper set of tables for
bookings, accountnumbes etc. In the form for bookings i tried to fill out the
property RecordSource with a variable containing the companynumber, but this
does not work. The RecordSource is defined as form![Mainmenu].[strComp]. If I
put a Tekstfield on the form with the same name it appears properly. Does
anybody know whether it is possible to use such a construction for calling a
table?
Thank you for helping me,
Regards,
Dick
 
Dick,

No it is not possible to use such a construction for calling a table.
You could do the equivalent, though, with a VBA procedure, for example
on the Open event of the form, something like this...
Me.RecordSource = [Forms]![Mainmenu]![strComp]

It sounds like you have separate tables for each company. This is
probably not the best design.
 
Back
Top