Is it possible to link a subform to a form without having a sub ta

[Guest]

I have a subform that contains a combo box with IDs. When I select the ID, it
brings up the customer info in controlled text boxes. So when I go to the
next record on the main form the subform remains the same.

Is there a way to link the subform to the main form without creating a
subform table and connecting master and child links? I don't want to store
any more excess data than necessary.

Thanks,
Dustin

 

[Guest]

I can't figure out why you are selecting a customer in the sub form if you
are not storing your selection, can you be more specific about what you are
doing?

If you want the value in the combo and the corusponding text boxes in the
sub form to change when you move to a different record, then on the OnCurrent
event of the main form write the code that initiate this field

Me.[SubFormControlName].Form![ComboName] = Null
Me.[SubFormControlName].Form![TextBoxName] = Null

 

[Guest]

I guess I want to select the customer info on the subform then when I come
back to that record on the main form my selection is still there. But it is
not critical to store the customer info. I was just curious if I could link
them without having to record the child link. I can get by without doing
this, so not big deal.

Another question though, I do have another subform that is linked and I am
short on space. Can I put that subform on a tab and have it so that it
remains linked to the main form?

Thanks Dustin

I can't figure out why you are selecting a customer in the sub form if you
are not storing your selection, can you be more specific about what you are
doing?

If you want the value in the combo and the corusponding text boxes in the
sub form to change when you move to a different record, then on the OnCurrent
event of the main form write the code that initiate this field

Me.[SubFormControlName].Form![ComboName] = Null
Me.[SubFormControlName].Form![TextBoxName] = Null
--
Good Luck
BS"D

I have a subform that contains a combo box with IDs. When I select the ID, it
brings up the customer info in controlled text boxes. So when I go to the
next record on the main form the subform remains the same.

Is there a way to link the subform to the main form without creating a
subform table and connecting master and child links? I don't want to store
any more excess data than necessary.

Thanks,
Dustin

 

[Guest]

The sub form within the TAB behave just the same as any other sub form.
So, yes you can link the sub form in the TAB to the main form.


--
Good Luck
BS"D

I guess I want to select the customer info on the subform then when I come
back to that record on the main form my selection is still there. But it is
not critical to store the customer info. I was just curious if I could link
them without having to record the child link. I can get by without doing
this, so not big deal.

Another question though, I do have another subform that is linked and I am
short on space. Can I put that subform on a tab and have it so that it
remains linked to the main form?

Thanks Dustin

I can't figure out why you are selecting a customer in the sub form if you
are not storing your selection, can you be more specific about what you are
doing?

If you want the value in the combo and the corusponding text boxes in the
sub form to change when you move to a different record, then on the OnCurrent
event of the main form write the code that initiate this field

Me.[SubFormControlName].Form![ComboName] = Null
Me.[SubFormControlName].Form![TextBoxName] = Null
--
Good Luck
BS"D

I have a subform that contains a combo box with IDs. When I select the ID, it
brings up the customer info in controlled text boxes. So when I go to the
next record on the main form the subform remains the same.

Is there a way to link the subform to the main form without creating a
subform table and connecting master and child links? I don't want to store
any more excess data than necessary.

Thanks,
Dustin

 

[Guest]

Thanks for your help.

Dustin

The sub form within the TAB behave just the same as any other sub form.
So, yes you can link the sub form in the TAB to the main form.


--
Good Luck
BS"D

I guess I want to select the customer info on the subform then when I come
back to that record on the main form my selection is still there. But it is
not critical to store the customer info. I was just curious if I could link
them without having to record the child link. I can get by without doing
this, so not big deal.

Another question though, I do have another subform that is linked and I am
short on space. Can I put that subform on a tab and have it so that it
remains linked to the main form?

Thanks Dustin

I can't figure out why you are selecting a customer in the sub form if you
are not storing your selection, can you be more specific about what you are
doing?

If you want the value in the combo and the corusponding text boxes in the
sub form to change when you move to a different record, then on the OnCurrent
event of the main form write the code that initiate this field

Me.[SubFormControlName].Form![ComboName] = Null
Me.[SubFormControlName].Form![TextBoxName] = Null
--
Good Luck
BS"D


:

I have a subform that contains a combo box with IDs. When I select the ID, it
brings up the customer info in controlled text boxes. So when I go to the
next record on the main form the subform remains the same.

Is there a way to link the subform to the main form without creating a
subform table and connecting master and child links? I don't want to store
any more excess data than necessary.

Thanks,
Dustin