Search results

Yes!! I check your demo & know how to do. Thanks! again!!

Thank you very much!!

Sorry to make you confused... I mean not use the button, is the big subform field after update, the two small subform can auto requery

please check the pic

Me.Recalc same no use! I just only want to know, after update the subfom field, how to requery the main form field?

Hi theDBguy Please check the attached file

I will prepare the sample file for you

it not work use in subform field AfterUpdate event...

can you give me some code sample?

"A" field is in subform, "B" field is in main form

Hi, How to requery "B"after entry a new record in "A"

Thank You!!

Hi, I can't run a query record, when I lookup from a form unbound field Picture1 & 1a is OK by the criteria like "1903*" But in Picture2 , 2a & 2b,it does not seccess

Hi, I use the following code in a query... SELECT [tblData].[ID], Conc("Field1","ID",[ID],"tblData") AS Field1, Conc("Field2","ID",[ID],"tblData") AS Field2 FROM tblData GROUP BY [tblData].[ID]; but I want to change the [ID] field from number to text.. so how to change the code?

I have many records in query, crosstab is too many fields... I think vba is good to me. Thank you so much!

How to use modules to convert query from A format to B format? A Format 101001 A2 101001 A8 101001 C1 101001 D12 101002 B12 101002 C1 101002 J10 change to...B format 101001 A2, A8, C1, D12 101002 B12, C1, J10 Thanks!

litem Loc 101001 A2 101001 A8 101001 C1 101001 D12 101002 B12 101002 C1 101002 J10 change to... 101001 A2, A8, C1, D12 101002 B12, C1, J10 Thanks!

Thanks so much!!

I need to open "CHECK_OUT_1" form's by different record source, so need to open by different button, can't use Open Event.

Hi, I use this code in form button, to open another form, but is not work... Form!CHECK_OUT_1.Form.RecordSource = "CHECK_OUT_data_1" DoCmd.OpenForm "CHECK_OUT_1", acFormDS, "", "", acReadOnly, acNormal