Search results
-
H
Set values in subform when opening main form
Ok I have my form called FQuotation with a subform on it called SFProdQuote from the table TProdQuote and has the fields: refproduct, quantity, quote and PQTotal. The way it is set up my subform opens with blank fields and awaits user to pick products one by one on the combox refproduct. I do... -
H
Set values in subform when opening main form
That's assuming i'm a genius like you! ;) The subform is link to a table. I tried do a query but doesnt return the set of records i want. I'm not familiar with recordset. do you know a good exemple? Thanks a lot -
H
Set values in subform when opening main form
Hello, I'd like to know how to set values to a subform when opening a main form I have a quotation form called FQuotation with a subform on it. This subform is the link between the products and quotation it is called SFProdQuote and has the fields: refproduct, quantity, quote and PQTotal. Once I... -
H
Passing data onto another form
Thank you so much it worked like a charm I hope this helps someone else to pass data to another form. -
H
Passing data onto another form
Thank you so much for the codes The data transfers but goes to the first record I need the form to open to a new record and put the things in Do you know how and where to put open new? Thanks so much for your help You're a life Saver!!! -
H
Passing data onto another form
Here is the code from the cmd button to Open Form 2 I did it with a wizard (dont laugh I'm a newbie) ;) Thanks for your help Private Sub ComOpenOrder_Click() On Error GoTo Err_ComOpenOrder_Click Dim stDocName As String Dim stLinkCriteria As String stDocName = "F Orders"... -
H
Passing data onto another form
I do not know how to pass with OpenArgs Could you give me a code exemple Form 1 = F Quotations Form 2 = F Orders Form 1 fields to pass = QuoteID, RefCust*, Quote Ex: QuoteID = 123, RefCust = abc company, Quote = $300 Form 2 fields to receive = RefQuoteID, RefCust, RefQuote *RefCust refers... -
H
Passing data onto another form
pass data from one form to another My second form has 2 many info and the first form already has a subform I need to pass info from that quoteID on form 1 to refquoteID on form 2 Can you help? please -
H
Passing data onto another form
Hi, i'm quite new to Access and I have a problem passing data from one form onto another. I have a form that I use for quotations based on the table T Quotations on it I have: QuotationID as my primary RefCust referring to which customer Date and a few other fields Now i'd like to add a button...