Paul M. Jones
pjones at btl.net
Tue Apr 20 11:25:14 CDT 2004
for situations like this I usually place the SQL statement in code rather than the control properties at design time. I then populate the row source on 'enter' of the combo box. Of course there are some overhead associated with this but I always get fresh data. I can also populate the combo box based on values in other fields using this approach. Paul M. Jones At 11:09 PM 04/19/2004, you wrote: >I have a combo box that pulls up matching records on a form. The data source >is a SQL statement not a query. > > > >After the record is entered where and how should I write the requry >statement to add the record to the combo box? > > > >JOE HECHT > >LOS ANGELES CA > > > >-- >_______________________________________________ >AccessD mailing list >AccessD at databaseadvisors.com >http://databaseadvisors.com/mailman/listinfo/accessd >Website: http://www.databaseadvisors.com