var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: unbound form w/subform
my database is used for asset tracking. pretty much what users are assigned to what equipment. I have a unbound form that contains a listbox which populates all the fields using VBA
on that same form i want to put in a subform that points to my users table to supply information about the user
when i try to setup the master and child link in the subform i am getting the error "cannot build a link between unbound forms.
problem is I am not quite sure how to link the computer selected in the list box to the subform which contains the assigned user's information
As the error implies, you can't have master/child links with an unbound form. You could do something like this in the after update event of the listbox:
Me!SubformControlName.Form.RecordSource = "SELECT...WHERE UserID = " & Me.ListboxName
Last edited by pbaldy; 05-06-10 at 14:44.
I assume you are trying to use the wizard/builder (click the "..." button). This only wiorks with bound forms.
Originally Posted by mike.burns7
You will have to manually type in the references to the list box for the master linking field. You will also mave to manually enter the child linking property.
Learn something new every day. I didn't realize you could do master/child linking with an unbound form.
Thanks for the help!