Combo boxes and Subforms

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

Guest

I am creating a form with a subform. On the main form I have one unbound
combo box which is populated by a query that list the names of all AppNames.
I have also created a subform with all fields pertaining to each AppName such
as (Description, Password etc.) What I would like the user to be able to do
is be able to select an AppName from the combo box and then in the subform
all of the information pertaining to that App will be shown. I have tried to
set this up before but when I select a field from the combo box so that it
displays it's information, the data in the subform changes (meaning the
information gets updated with the field of information that is for the next
field)

Any help will be greatly appreciated..
Thanks
 
Steve,

I am getting the following message when I try to set the subform LinkMaster
field "Can't build a link between unbound forms".

Please let me know what I am doing wrong.

Thanks
 
I have a combo box that is populated by a table that does not allow
duplicates and the table only has one field (AppName) which is the primary
key. I have also created a query that is based on the table (AppName) which
I use to create my main form. So on my main form I have only the combo box
(AppName) then I created a subform. My subform is generated from another
table (Master). In the Master table I have all data relating to the AppName
such as (Password, Description, etc.) My goal is to be able to select a
AppName from the ComboBox and then all of the information pertaining to that
particular AppName will appear in the subform. One AppName can have many
details in it.

I have tried to set this up by making the MasterLink be the name of the
combo box but it is not working. It is rearranging the information in the
subform once I select an AppName from the combo box. Can someone please help
me?

Thanks
 
Back
Top