noob ? - how to create unbound subform?

Matrix_zero

Registered User.
Local time
Today, 07:34
Joined
Jan 26, 2005
Messages
64
How do i create an unbound subform on an unbound form? I want to bring data in from another table/query if the data exists.

I am pullind residential property data, if there are recent sales i would like to pull that too.

I know this is a pretty broad question, but any help would be appreiciated, exmaples would be awsome to. Thanks.
 
Matrix,

Just wondering why you're so intent on unbound forms?

In a bound form, you can just set the Master-Child relationship and
let Access handle everything.

With your unbound forms, you will have to control the synchronization
between the Parent/Child forms. Basically, when your parent form
changes context (displays a different record), you will have to open
a recordset, display the first child record. Then handle the navigation
within the child record.

The design topics that you'll face include detecting modified child
data (when the parent record changes) and updating the recordset(s)
accordingly.

I don't have any examples, because I try to stay away from unbound
apps when I can.

Wayne
 

Users who are viewing this thread

Back
Top Bottom