Search results

Hi guys, really sorry about this, I have solved the problem (the origional vb code worked). I must have changed the record source (in the query) of the form when testing - so this was causing the vba code not to run properly. Sorry agan for wasting your time.

Hi, thanks for your suggesion, here is what I changed my code to: Dim strfrm, strWhere, strpono, inputBoxRes As String Dim intpono As Integer Dim rs As DAO.Recordset Set rs = CurrentDb.OpenRecordset("TblOrder", dbOpenDynaset, dbSeeChanges) strpono = InputBox("Please enter the purchase order...

I am trying to open a form with the ID from an inputbox (the ID is a number), if the ID does not exist a error messege pops up, which works. If it does exist I want the form to open with the ID which is typed in the inputbox, which does not work, instead, the form does open but is showing...