Hello Ilona, Gotta say I find this one a little strange. I've never seen a function in a rowsourcetype before, didn't know you could do it.
Is there any chance you could post a copy of the app so we can take a look at it? Another Adelaide boy. Robin. --- In ms_access@yahoogroups.com, "Ilona Wright" <[EMAIL PROTECTED]> wrote: > > Thank you John for your prompt reply. I will keep plugging away at it. > Ilona > Adelaide, Australia > -----Original Message----- > From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] > Behalf Of John Viescas > Sent: Wednesday, 9 November 2005 11:05 AM > To: ms_access@yahoogroups.com > Subject: RE: [ms_access] Row Source Help > > > Ilona- > > I have no idea why they put something in Row Source - the function > provides > all the rows for the combo box. > > John Viescas, author > "Building Microsoft Access Applications" > "Microsoft Office Access 2003 Inside Out" > "Running Microsoft Access 2000" > "SQL Queries for Mere Mortals" > http://www.viescas.com/ > > > -----Original Message----- > From: ms_access@yahoogroups.com [mailto:[EMAIL PROTECTED] On > Behalf > Of Ilona Wright > Sent: Tuesday, November 08, 2005 4:40 PM > To: ms_access@yahoogroups.com > Subject: [ms_access] Row Source Help > > Hi John, > I need more help. It has been a long time since you helped me last and > unfortunately I have not progressed much from then. > > I am using ACCESS 97 and am trying to learn Access Basic by working > through > some of the SampleForms given in the Developer Solutions database and > appling their great ideas to what I want to do. > I have been looking at the Sample Form AddAllToList. > In the combo box SelectCustomer the Row Source Type is the function > AddAllToList and the Row Source is CustomerList. I can't work out where > this > CustomerList comes from. I know it is selected from the drop down menu > that > displays when the focus is on Row Source, but I cannot see where > CustomerList is originated. > Can you enlighten me on this? > I have looked at what I believe are all the objects in the Developer > Solutions database, but cannot find CustomerList. > Thank you in anticipation > Ilona Wright > Adelaide, Australia > > > [Non-text portions of this message have been removed] > > > > > > Yahoo! Groups Links > > > > > > > > > > > SPONSORED LINKS Database development software Database management > software Database software > Inventory database software Membership database software Microsoft > access software > > > ------------------------------------------------------------------- --------- > -- > YAHOO! GROUPS LINKS > > a.. Visit your group "ms_access" on the web. > > b.. To unsubscribe from this group, send an email to: > [EMAIL PROTECTED] > > c.. Your use of Yahoo! Groups is subject to the Yahoo! Terms of > Service. > > > ------------------------------------------------------------------- --------- > -- > > > > [Non-text portions of this message have been removed] > ------------------------ Yahoo! Groups Sponsor --------------------~--> Fair play? Video games influencing politics. Click and talk back! http://us.click.yahoo.com/T8sf5C/tzNLAA/TtwFAA/q7folB/TM --------------------------------------------------------------------~-> Yahoo! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/ms_access/ <*> To unsubscribe from this group, send an email to: [EMAIL PROTECTED] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/