Search results

Thanks anyways CJ London, I actually solved the problem by putting =[Forms]![Order F]![PackingSlipT subform]![PackingSlip_ID] in the PackingSlip_ID default value in product form.

The control names are fine. The reason I have PackingSlip_ID in the product table, is to have a one to many relatioship ( many product_IDs for one packingslip_ID).

I checked the code. But I am not sure about the the name of the control in my product form. Anyways, the relatioship between the packing slip and product is as following: (PackingSlip_ID, Date)-||------0<(PackingSlip_ID(foreign key),Product_ID(primary key))

Private Sub PackingSlip_ID_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String stDocName = "ProductT" stLinkCriteria = "[PackingSlip_ID]=" & [PackingSlip_ID] DoCmd.OpenForm stDocName, , , stLinkCriteria, , , PackingSlip_ID End Sub

I may misunderstand. Please clear me if I am wrong. I put the following code: Private Sub Form_Current() PackingSlip_ID.default=me.openargs End Sub in my product form, but when I click on Packing_Slip ID on the PackingSlip table to open the product form, it gives the "Compile error: method or...

I tried above code in my form, but I get an error when I open the form. Just to make it clear, I have two forms( PackingSlip form and Product form), and as you mentioned I want to populate the PackingSlip_ID field on the new product form (when new record is added). In addition, being able to...

For the above situation, is there a way to open a table/query that shows the current records related to the PackingSlip_ID. Is it also possible to add new records to that opened table.

Thanks CJ_London. It worked.

I want to Double-Click on a row of a subform to open a related table/form that are connected with a common ID. So far, I tried the following code, but it does not work. Private Sub PackingSlipT_subform_DblClick(Cancel As Integer) Dim stDocName As String Dim stLinkCriteria As String...

I am talking about data addition

I am looking for a way to limit the number of rows that are added to the subform of a main form. Is there anyway that the allowable number of rows be defined using a field on the main form.

You are completely right. I previously had a condition in my report's button settings. So I removed that, and now it perfectly works.

Sorry, I was wrong. The approach you mentioned was enough. I had extra filtration in my report settings as well, that was the reason it was not working. So I just removed that condition and it works perfectly. Thanks again.

Thanks a lot Paul. I put that criteria in the record source and it works. But, every time I open the report, a parameter page pops up and asks me about an ID. Is there a way that when I click on the report button on a mainform, it automatically reads the mainform ID and open the form only...

I have a subform in a main form. I want to put those new added items in the subform (or the selected ones if possible) to be appeared in a report with other information that is coming from other tables. So, my approach to this matter so far, was to create a query and then used that as source for...

I have a main form (Parent) along with a subform(Children). I want to have a button that generates a report with the Parent information as a header and the items in the subform as details. In addition, I want the report to show only the children that were recently added not all of the children...

Thanks, I used the link you put above and it worked.

It is a Navigation Form using the Naviagtion Form wizard with one level subforms.

Thanks Paul for your help. I actually changed the reference to the correct form. But, the form that I have is a navigation form with several buttons,which open other forms. When I changed the refernce, I do not get any error, but my search box does not work.

Hi, I have used one of the members' code which was posted in a tread before to create a search box in a form. This code works perfectly when the form itself is open. Otherwise, when I put this searching form along with other forms in one navigation form, I get the following error: "Enter...