Details of my Form:
Table Name: Properties Account Targeted
Fields Name: "ID"' "Properties ", "Rent Amount", "Targeted Rent" "Difference "
Combo box Table Name: Combo_value
Combo box Fields :"ID" "Properties ", "Amount"
Value under Target Rented were duplicated.
ex:
[Properties] [Amount]
Flat1 100...
Ashlot
Last Activity: Jan 16 '12, 08:42 AM
Joined: Jan 8 '12
Location:
-
Sir how to identify the required line by the [Property List] sir?Leave a comment:
-
Forgive me sir because i am new on this program. Yes sir i have combo box and if i select,it selected only the first one.Only the amount is duplicated sir.Leave a comment:
-
"And they're using code to populate the amount depending on the selection in the combo box that lists the flats, probably using some sort of DLookup. But since there are duplicates, it can't uniquely identify which record to use so it just uses the first one." Sir Rabbit this statement was my problem.And Sir Neo how can i identify the whole record?Leave a comment:
-
I am sorry if my explanation are very complicated.Thi s are the details of my form:
Table Name : "Properties Account Targeted"
Fields Name: "Properties";"R ent Amount";"Target ed Rent";"Differen ce"
Where "Properties " is the combo box and combo box Table name is "Combo_valu e"
"Combo_valu e" was composed of two fields which are "Property...Leave a comment:
-
Hi Neo...
Thanks for responding.But i already tried those things Yes(No Duplicates)and No but still not working.
this is the ex:
Tablename - "Combo_valu e"
Fieldname - "Properties " and "Amount"
"Properties " field is the combo box and the amount every time it clicks the list in the combo goes directly to "Amount" field.
Properties Amount...Leave a comment:
-
How do I Allow Duplicate Values in a Field
Hello
I got a problem on my combo box.I am now using ms access 2007.It is that when u select the list on my combo box there is some value that selected and the others are not.The list on my combo box have some amount that every time u select on the list there is amount that goes on the other field.I think its because the amount which i put on the value of the list have lots of duplicate. How can i allow duplicates value on a field.T...
No activity results to display
Leave a comment: