ParameterBox vs. Combofield

[Nitronomus]

Hi!

I've a lil' problem here:

'1. Try
    stLinkCriteria = "'[namen]![team] = Me!Kombinationsfeld1' and"
    stLinkCriteria = stLinkCriteria & Statusr & Welche

'2. Try
    'stLinkCriteria = "(" & "team=" & "'" & Me![Kombinationsfeld1] & "'" & ")" & "and"
    'stLinkCriteria = stLinkCriteria & Statusr & Welche
  
  stDocName = "Bericht 582 offene Aufträge für E4"
  DoCmd.OpenReport stDocName, acPreview, , stLinkCriteria

I click a button, and when it runs this Rountine it wants a parameter for "team" (It's part of a linked table). But this parameter is configured in the combobox named "Me!Kombi....". It happens on the 1. also on the 2. codepiece.

I've no idea what the problem is or how I can avoid this "parameterbox". Maybe I'm just %-).

K, I hope you'll understand my *lol* german English and can help me with this.

Bye & BB

 

[Steve101]

Try the following:

stLinkCriteria = "Team = '" & Me!Kombinationsfeld1 & "' and "
stLinkCriteria = stLinkCriteria & Statusr & Welche

Though I dont know what Statusr and Welche are, so dont know if it will work. The above should fix the Team part anyway. To test it separately if you need to, just use

stLinkCriteria = "Team = '" & Me!Kombinationsfeld1 & "'"

Good luck
Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au

 

[Nitronomus]

hmmm, thx.

This was one "error". I've found another which was the main reson that this was not workable.

But thx & BB

Daniel

 

[Steve101]

hmmm,

Sounds like I wasted my time on this one. Hope youve got it sorted out. Cheers,

Steve Lewy
Solutions Developer
steve@lewycomputing.com.au