By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
428,997 Members | 1,470 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 428,997 IT Pros & Developers. It's quick & easy.

Sorry Allen

P: n/a


Hi Allen,

it appears I was too hasty with my previous post. The recordsource is
being reassigned to the one that you provided in the
cbxSelectContact_AfterUpdate. However, the form is still not displaying
the record.

thanks Allen

Colin

*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!
Nov 12 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
You are assigning a SQL statement to the RecordSource of a form, such that
it displays only one record. Is it displaying nothing? Or the wrong one?

If nothing, check the data type of the field, and use the appropriate
delimiter.

If the wrong one, verify that the change of RecordSource worked by adding
this line:
Debug.Print Me.RecordSource

--
Allen Browne - Microsoft MVP. Perth, Western Australia.
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.

"ColinWard" <je*********@hotmail.com> wrote in message
news:40*********************@news.frii.net...

it appears I was too hasty with my previous post. The recordsource is
being reassigned to the one that you provided in the
cbxSelectContact_AfterUpdate. However, the form is still not displaying
the record.

Nov 12 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.