Recent content by Badvoc

Sorry I miss-understood your question, but Iv solved it now, I found a post by Baldy with a link on how to "Open a second form to the record selected on the first form, but still include all records" a bit of code changes and it works for me :) Dim rs As Object 'open the new form...

15945 total records in table, the form gets its data from a query of the SQL table

Dim stDocName As String Dim stLinkCriteria As String stDocName = "frmForm" stLinkCriteria = "[DrawingNo]=" & "'" & [Text0] & "'" DoCmd.OpenForm stDocName, , , stLinkCriteria Sorry shoun't of changed it.

Hi we have a database frontend/backend and am moving the backend to an SQL server. This seems to have stopped the next and previous button working on the form although the add new button still works. The form is opened to a specified record via and another form using this code Dim...

thanks but i need it to work in the query, I cant believe ACCESS finds this so hard

in the case of frank clarke, 1 would return all in list 4,4,5 & 6 4 would return just the 4s null will never happen nor will 10

Im still stumped on this :(

added .mdb file

heres a stripped down db

im working on one now ;)

Hi Ari thanks both only half work, first one works if the number is in list (priority field) but shows no records if its not a match. second show all records if the number is in the list and all records if its not. If the number is in the list, filter only for the number, if not, show the list.

when I try that the true part returns all records when theres a match very frustrating these queries

this returns no records. if [Forms]![frmTRinput]![Text103] is 2 and theres no 2 in the priority field. If [Forms]![frmTRinput]![Text103]=2 and theres no 2 in the priority field I want all records in the filed to show

HI I have this in the criteria of a query field name priority IIf([Forms]![frmTRinput]![Text103]=[priority],[forms]![frmtrinput]![text103],[priority]) [Forms]![frmTRinput]![Text103] will be any number 1-7 depending on user input. Priority is in a table and might have any combination of numbers...

If anyones got an answer for this, it would be nice.