Search results

Yes, communication was obviously a problem. I'm an intemediate VBA programmer, and It was hard for me to explain this problem as english is not my native language. I knew there has to be some way with RecordSetClone, since I have done pretty much same thing with exporting to Excel, using...

I thought we understood each other - I didn't mention anything about entering same values, otherwise I would explicitly tell you that. I told that I need to see current records on report, that's It. And I know It can be done, actually It works when you add these lines before opening report...

I really don't get It, really. I doesn't work for me, take a look. Now very strange thing occured - when I opened your posted sample directly from Winrar, code worked, but once I downloaded to computer, code works as you'll see in printscreen :banghead: EDIT - It tried again. Now It doesn't...

Yes It doesn't work. In my DB and in this Sample file I posted.

I'm sorry to say, but this doesn't work. actually before posting anywhere I tried same with Me.Save, Me.Requery, Docmd.Runcommand accmdSaveRecord & accmdSave, even Me.RecordSource=Forms.Results.RecordsetClone doesn't work. Test it in my sample and you'll see. Do you have any other ideas ?

Ok, seems like you understand It. Where should I put this dirty=false statement, can you show in my sample ?

Ok, I'm done, here is sample. Open form "Search" and type "Paul" (or whatever in Table1 is). Then "Results" form will open in this record. Click on report button - you'll notice this record is in report too. After that, type some new records in form "Results", and then click on Report button...

Ok, I will post a sample later and you'll see what I'm talking about. I just have to come home again.

Yes, all rows are inserted. Yes, when I perform search again for newly added record, "results" form shows this record.

I have opened "results" form. It has allready data in It. Now I add new record and save record. Then I open table where It should be, and It is. Is this what you meant ?

No, let me explain a little bit more....I have a "search" form - based on criteria I enter in Textboxes here,,, a form with results is opened - with recordsource in continous form as I searched. So recordsource is allready defined here. Now, let's say I search for something that isn't in table...

Sure, here It is. I googled all over, and your thread is only one I found so far: stackoverflow.com/questions/36631021/access-report-show-current-recordsource-of-another-form/36634451#36634451 I haven't post a lot on this forum so far, that's why I couldn't post entire link (http is...

Hi guys, I seee this is an old thread, but I'm facing same problems. Any way to post some example code, I'm not folowing your answers exactly ?

Hi, I have a continous subform with code that automatically resizes subform according to number of records in It. Under subform I have many controls that need to be moved too, based on subform size. When subform's size is bigger, control must move down exactly same - or move up. I have a code...

Hello everyone, I have one problem that Is killing me, and I'm an Access beginner. Problem description: I have Main table with fields also for Maintainance_Man, Technic_Man and User. Then I have second table with fields _Name,_Surname. Those three fields in first table should have...

I thought I was clear... Ok, question is - Can I open my form which is made from "leading" table and linked subforms(tables) in that way so that AUTONUMBER field woudn't be set as "Autonumber", but It would already assign new number of record without entering nothing (As it does when you enter...

Hello, I am working on school project. I created priority table that has primary key (ID number) and other data, and three tables(also with data) that are linked to this table, with ID number of priority table and primary keys of other tables (relations many-to-many, I formed tables between...