Search results

There are no on current events for either the main or sub form :( The only thing that is different between the previous/next and first/last navigation buttons is the "on error" and message box about being on the first or last record already. I deleted that portion of the code and tried a...

I'm sorry I'm not being clear, I have been trying to figure out this problem for a while and I am having trouble putting it into words. I do not want the navigation buttons to take me through the subform, they control the main form only. I know the previous and next buttons work because...

I have a form that has a subform on it. The main form shows a category of furniture and has custom navigation buttons and a search text box for asset numbers and command button that runs the search. The subform shows the asset numbers associated with that furniture category, sometimes there is...

Just to see what, if anything, it shows - I made the navigation buttons visible on the form. Instead of showing as one full list, the main form breaks down into "records" when the button to filter by departments is pressed. One department has 8 rooms in it, and instead of showing a list with 8...

Yes the query shows all of the rooms for the department if I ask it to only filter for the department. Sorry I wasn't clear about the linked fields for the subform: The linked master fields are DeptID;RoomID The linked child fields are DeptID;RoomID

Thank you! The same thing happens when I leave it off, it just shows the first room for the department. I have tried to add these criteria directly to the query, and they give the proper results. Do I have a relationship set up wrong? I have attached a snapshot of the query in design view.

Hi! I have a form [Art_DepartmentFilter] that has a subform [Art_ByRoomSubform]. The linked master/child fields are DeptID and RoomID. There is a list box on the form that allows you to select the department, and this also updates a list box that shows the rooms in that department that have...

Adding that code just gave me a compile error "method or data member not found." After doing some more research I know that even though the subform is continuous, because it is a subform it only recognizes that one item code that has the focus and ignores the others. So me trying to find...

Hi! It is a number field.

Good day! I feel like I am very close to solving this but because I'm a little rusty in my vba I cannot seem to figure this one out. I have a main form "Furniture_CatCodeAssets" which shows detail specifics about certain furniture item codes (width, height, colour etc.). I have a subform...