Hi all
I have a split form where the top half displays some agency information and the bottom half is a datasheet that contains records with more details. I have a form button for users to add new records and when I went to fill one out, I hit save, then close on the form but whenever I try to type in the agency name in the search bar, it doesn't show up on the datasheet. However when I look on the main table, I see the record is there. For some reason it's not showing up in the datasheet. Even though the split form's record source is a query that uses this main table. Thoughts?
Any feedback helps. Thank you.
I have a split form where the top half displays some agency information and the bottom half is a datasheet that contains records with more details. I have a form button for users to add new records and when I went to fill one out, I hit save, then close on the form but whenever I try to type in the agency name in the search bar, it doesn't show up on the datasheet. However when I look on the main table, I see the record is there. For some reason it's not showing up in the datasheet. Even though the split form's record source is a query that uses this main table. Thoughts?
Any feedback helps. Thank you.