switchof
Last Activity: Dec 20 '11, 01:30 PM
Joined: Aug 25 '11
Location:
-
Bumping it cause I still didn't find the solution so would need help -
How to solve error 3211 in Access 2000?
I received the error 3211: database engine could not lock table TF_Classificati on as it's been used by another person or process on the line bolded in the below code: tblWM.Fields.Ap pend fldWM
I already tried 2 ways:
1. to close the recordset and set the object to nothing
2. close the table using the command: DoCmd.Close acTable, "TF_Classificat ion", acSaveYes
but none works, so any idea?
... -
What did you ask NeoPa? I thought I've responded to what you posted.
Actually this question is related cos say in my previous question, lst2 is on subform and lst1 is on the parent form.
So besides lst1, there's a combo box on parent form.
And besides lst2, there are text boxes on subform to display the details of a bank account based on what is selected on lst1.Leave a comment:
-
Now I have a problem to synchronise parent and sub forms.
Say in parent form I have a combo box that when a value: a person is selected, a list box on the same form will be populated with the bank names where this person holds account and address of the branch.
I have to use query to populate the list box also cos the bank name and address are held in 2 different tables.
A person can be connected to more than 1 banks and...Leave a comment:
-
How to Synchronise Parent and Sub Forms
** Edit **
This post was posted by mistake into another thread (To populate listbox in subform from value selected in parent form), which may contain details relevant to this question.
**
Now I have a problem to synchronise parent and sub forms.
Say in parent form I have a combo box that when a value: a person is selected, a list box on the same form will be populated with the bank names where this person holds...Last edited by NeoPa; Aug 29 '11, 04:51 PM. Reason: Moved to new thread from hijack post and added a linkback -
I found the answer!
So I populated the rowsource of lst2 on OnClick event of lst1.
And apparently what I should write is:
Then I put:Code:Forms![ParentFormName]!PageA1.Controls!SubFormName.Controls!lst2.RowSource = "Query1"
so that when another row is selected on lst1, lst2 would be populated with the children of the selected...Code:[ParentFormName]!PageA1.Controls!SubFormName.Controls!lst2.Requery
Leave a comment:
-
NeoPa, unfortunately it didn't work :(
I used ! instead of . and still didn't work.Leave a comment:
-
Say I have the parent form: FormA that has a listbox: lst1 and it has a few rows say displaying people's names.
When a row in this list is selected, it should populate a listbox: lst2 on the subform: FormB, with relevant data, say the selected person's children.
I put the subform on a page of FormA actually, say PageA1.
I suppose I should populate lst2.rowsource with query that selects the children where parent = lst1.value....Leave a comment:
-
To populate listbox in subform from value selected in parent form
How can I populate the list box (list 2) in subform from a value selected in a list box (list 1) in parent form?
I can put in the row source of list 2 a query to match a table's field to the list 1.value, but I don't know how to pass this value from parent form to subform and where I should populate the row source of list 2.
Thanks for any tips.
No activity results to display
Leave a comment: