Recent content by JoséBob

Thanks. It indeed workes. The final line of code is following: Forms!MainForm!SubForm.Form.Recordset.FindFirst "ID = " & intRecordID I had an additional issue with the name of my forms which was not correct (beginner's mistakes, sorry...). Thanks all for your time and support.

Thanks for the little pictures: very helpful indeed. You're right for most of the situation. Using your picture: on 3, I have a button "save". When I click on save, I want to see 2 updated (without closing 3) and the focus being on the record 380. I tried ebs17's solution but it doesn't work...

no worries I need long explanations to understand quickly ;) The filter runs well on the continuous form. yes. Most of the time. And indeed, if not, there was no need for my question. The filters applied shall not change after the update of a specific record. But after scrolling to a specific...

That's correct. But as stated in the other answer, the user can filter on Field1 and have multiple records and edit one particular record. Thus the question. It will also avoid the need to scroll back again to the current record to continue their editing. That's correct. The subform LogHeader...

Hi, Thanks for trying to help. I’ll rephrase: Main form: loglist. Has filters. It is used as a sort of header for the continuous form. subform: logheader. Is a continuous form. as you said, Thanks for your answer. My problem is 1/ the need to show the updated record on the continuous form and...

Hello, I have a continuous form on which the user can navigate through record. When found, the user can click on a record to view or edit it (nothing new here). The continuous form (let’s call it LogHeader) is a subform of a form (LogList) and on the form there is a header than contains...

Thanks all for your answers and the discussion. I used a query and based both my reports on it. I put the conditions/criteria of the query in the vba code and used Select/Case to get the different situation.

Ok.

When executing line by line, in a module as a public function, vba doesn’t like the very first line (docmd.OpenReport “reportMain”). It pops an error message run-time error 2212.

That another option which looks easier. I’ll try as well (or maybe at first). I can see what I was missing at first is that the filter should be in the onload event of the subreport and not in the opening event of the main report. Which I didn’t mention in my question. i guess that using...

Good idea. I’ll try and let you know. I’ll post a sample in the mean time.

Hello, I have a report (ReportMain) with two unbound subreport (Sub1 and Sub2). I would like to create the report through VBA so that the user can input custom date (field Date/Time of the table Log). when using the VBA code docmd Openreport, I can pass the condition to the whereCondition. It...

I found the issue… I was using the field the attachment field instead of using the .filedata subfield. This works. Indeed, when using the attachment type in a table, Access creates “sub fields” .filedata, .filename, .filetype. If one uses the main field, it doesn’t discriminate the attachment...

The second subreport (the one with the pictures) has its datfrom a query that selects only records with attachments. I’ll have to check if there are links as you say. The first subreport has its data from the [log] table. That table also contains all the data including the attachment. but based...

Hei Pat, Thanks for the explanation. It is indeed clearer. about the images, I also tried the print preview. If you look in detail, you’ll see that for the same record number (on top of the page) there is the same picture twice although there are two different in the database.