Hi Furlow,
Sounds like sort of an odd way to go about things, but I'm sure you had your
reasons....
As for getting data to show up in a form, basically it's like this:
Forms that display data have a recordsource. That recordsource is either a
table or a query, and that table or query contains the data you see in the
form (there are exceptions, but that's mainly the way it works). So, your
form needs to be 'bound' to the recordsource whose data you want to display.
You do that by going into the form's properties and setting the recordsource
property to the appropriate table or query.
Once you do that, then you have to go into the properties of each control on
your form. Controls, in this context, are things like combo boxes and text
boxes. In the properties for each of those controls, you have to set the
control source property to the individual piece of data (field) that you want
to display in that control.
In version 2003, if you open a form in 'design' view, don't click on
anything after you do so, and then hit the f4 (function key 4) the properties
window will open and it will display the properties of the form. The
recordsource property is on the tab 'data' at the top. After you set that,
click on one of the controls on the form and look in the properties window
which will now be showing the properties for that control you selected. Look
on the same tab for the control source property and use the dropdown arrow to
find the field you want to bind to that control.
Hope that helps,
CW
