Combo and Subform

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi - I created a form with a subform. There is a field within that subform that I would like to use as a combo. See code below - not matching field from subform. Can anyone give an idea as to how it should read? I know the tblDesc subform should be in the code somewhere. HELP, please

Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark
 
Dear Priss:

While there are often good reasons for a question to remain unanswered,
sometimes they just get missed... I would guess your question has just
gotten lost in the shuffle. You can go to the following link for some
information about posting that might prove helpful, but in this case, since
two days have passed, you might consider reposting your question. You can
use the same subject heading, but put "Repost:" in front of it. That should
get you a response!
http://www.mvps.org/access/netiquette.htm

I'm no expert, so I hesitate to offer a suggestion, but is "ID" a number or
a text string? If "ID" is a number, then it might not be working because I
believe Str(Me![Combo1]) will return a text string.

HTH
Fred Boer



Priss said:
I have not gotten a response yet. Is there a reason why?
Click to expand...
subform that I would like to use as a combo. See code below - not matching
field from subform. Can anyone give an idea as to how it should read? I
know the tblDesc subform should be in the code somewhere. HELP, please
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark
Click to expand...
Click to expand...
 
Is there a reason why?

1/ The vast majority of people answering questions here do
so voluntarily in their own time.

2/As Fred said, you may just have been unlucky and got lost
in the mass of posts.

3/There may not be quite enough to go on in your post. I
can't see any reference to tblDesc, where does that come
into it? It is a fine balancing act posting anough to
permit analysis by others without overdoing it.

The only thing I can suggest based upon what you have posted
is to check, as Fred suggested, that the value being
returned by Str(Me![Combo1]) matches something in the
recordset.clone and is a matching type.


--
Nick Coe (UK)
www.alphacos.co.uk

---

Priss said:
I have not gotten a response yet. Is there a reason why?
Click to expand...
within that subform that I would like to use as a combo.
See code below - not matching field from subform. Can
anyone give an idea as to how it should read? I know the
tblDesc subform should be in the code somewhere. HELP,
please
Dim rs As Object
Set rs = Me.Recordset.Clone
rs.FindFirst "[ID] = " & Str(Me![Combo1])
Me.Bookmark = rs.Bookmark
Click to expand...
Click to expand...
 
Back
Top