When using the Create Page wizard, you can choose Form -> Form on a Table or View (instead of Form on a Table with Report). Your query can be a view and base your form on this view.
Thanks InoL, I tried that and put a runtime where clause in the 'fetch row' process. Problem is it does not seem to fetch a row, if it does it is not showing the values in the form. I also don't get the 'apply changes' button, I just get cancel and delete buttons. Thing is, this is all about updating a row I don't really need insert or delete.
Under debug I do see a message: skip because inline validation errors found, that's straight after the fetch row, so I guess that's why its not getting a row. But how do I found out the problem ?