Bound controls

[mcbass1]

Is it possible to have a form with controls that are bound to a query and be able to overwrite or update those fields/controls? I don't want the table the query uses to be changed, just the control on the form.

Thanks.

 

[thisisntwally]

im not sure exactly what you are asking here, but it is possible to bind a form to a SQL statement and programatically set the fields to display. Can you be more specific with what you are trying to do?

 

[mcbass1]

The controls in my subform update automatically when I select from a dropdown box in the main form. I'd like to be able to change the information in those controls if need be. Is that possible?

 

[thisisntwally]

I haven't worked much with subforms, but it seems to me that if you are trying to change the fields displayed by the controls in your subform, this should be totally possible.

see if this thread helps:
http://www.access-programmers.co.uk/forums/showthread.php?t=59959&highlight=dynamic+subform+control

and maybe search around this forum (and google) with the word Dynamic