Recent content by jprat
-
J
Solved need to add a new record via button based on filter from main form
oh, I see so that unbound textbox was causing the error! I see your code, but for my knowledge is there a good resource to reference on handling errors like this? I'm learning VBA and I've found random sites that provide bits of information. I just need something that would be more detailed... -
J
Solved need to add a new record via button based on filter from main form
Hi, thank you for adding that. Just to confirm, for the master/child fields-- instead of using what is available in the ellipses, I can actually chose to manually type in the field name as long as the data type is the same? i.e. field 1 data type is number and field 2 data type is number... -
J
Solved need to add a new record via button based on filter from main form
hi thank you for the reply! So, I do have the child/master linked by CaseID and EmployeeID. However, if I go your route-- I found that I would need to turn another table into a subform so that I can have a add button on that subform which allows me to create a new case, but I'd have to close out... -
J
Solved need to add a new record via button based on filter from main form
Hi, I'm new to vba/macros in access. I have a main form that is built from scratch with fields from different tables and I have a search filter on it. When the search filter populates an employee, I want to be able to add a new record (case ID) for that employee. I've tried different codes for...