new to access, control source question

[mmmk]

Is there a way to bind a text box to a control source that is outside of my form's record source, without using a subform? I am trying to add a text box which links to my Comments table, while the form's record source is the Events table.
Thanks

 

[boblarson]

Not really. You can DISPLAY information there using a DLookup, but if you want it to be updateable then you'll need to use a subform.

 

[mmmk]

Ok, Thanks!

 

[missinglinq]

And be aware that a subform doesn't necessarily have to look like a subform! Its appearance can be tweaked so that it simply looks like another control on your form, which means that it can be edited.

 

[boblarson]

And be aware that a subform doesn't necessarily have to look like a subform! Its appearance can be tweaked so that it simply looks like another control on your form, which means that it can be edited.

Exactly -

here's an example of a form with a subform - mmmk see if you can tell me which field is the subform:

 

[mmmk]

I can't tell! How do I edit the appearance of my sub-forms?
Thanks for all the help.

 

[G37Sam]

Exactly -

here's an example of a form with a subform - mmmk see if you can tell me which field is the subform:

The combobox that says Davilow, Tony?

 

[boblarson]

The combobox that says Davilow, Tony?

Nope, the text box that says Davoliow on the second row.

 

[G37Sam]

Aaah close call haha, I thought why else would you have two fields saying almost the same thing

 

[mmmk]

Can u explain how to do this please.
Thanks

 

[boblarson]

Oh, and here's the pic of it in design view (I couldn't do it last night as it was here at work):

 

[boblarson]

Can u explain how to do this please.
Thanks

How to do what? Put the subform on the form? If you create a query with just that field (and the FK field) you want and then save it and then drag and drop it on the main form it will bring up a dialog where you can let it supply the links (master/child).

then you can do some formatting - setting the control's special effect to FLAT, setting the border to transparent, etc.

 

[mmmk]

i got it! thanks for the help.