General information
Category:
Forms & Form designer
Title:
Anyone good at working with FormSets?
Hello All once again ;
I am having a problem working with a formset. On one of the forms, the user can select a company from a combobox, and in the valid of that combobox, I run a select statement based on the displayvalue of the combobox. If the recordset is larger than one(meaning more than one card assigned to a particular company) I then show the other form in the formset(frmSelectMember), and hide the current form(frmSettlMgr). The Table which is produced from the select statement within the valid of the combobox from the other child form(frmSettlMgr)is the recordsource for the listbox on FrmSelectMember. The problm that I have is that every thing works the first time I select the company with many Records, however if I delete a record, then select the same company, I get the error "Cannot Access the Selected Table"!!!
BTW : I am not using a Private data session
Should I be using a view for the recordsource of the listbox instead of a table? I am not sure if that will help, but I am sure that the change will take a bit of time to impliment, of which I have NONE! hehe
Oh yeah, also: the problem only occurs when I delete an Item(card number) from the Original table that I am selectimg from... the item deleted remains in the table(just marked for deletion)
Any Suggestions?
Thanks
Rickster
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only