How to Update Product filed

S

sandya

Registered User.
Local time
Today, 19:47
Joined
Oct 27, 2013
Messages
82
Can anyone help on My Products field update issue in form

i have a created Products form with table require

they details are:
Ex:
ID--Brand --- Model -- Color -- - Product
----------------------------------------------------
1---LG Ref -- 123456 ---Red------LG Ref 123456 Red
2---LG WM---123457---White-----LG WM 123457 White
3---TATA-----223652---Silver-----

Above Brand, Model, Color & Product filed details are same.
So above Brand, Model, Color Details are need to update in Product Field with automatically without typing. So any VBA code or any formula will be update automatically??
i have attached the screen shot please replay anyone:banghead:

Advanced Thanks
Sandhya.
 
Last edited:
Hope that the Product is NOT a field in your table.
If it IS a field in the table, remove it ! Now !

So you have a form based on table tblProducts.
In the detail area you have 4 (four) controls (text boxes) bounded to the table fields.
Usually, the names for this controls are the same as the bounded field.
Create one more UNbound text box. Name it Product.
In the control source type:
= Brand & " " & Model & " " & Color
Save and run the form.
 
But Product field is primary key & relation ship with some tables. Can't remove it:confused:
 
So why do you have an ID field in the table? What prompted you to include that field in your table?

That is the field which should be used in other tables.
 
i have attached the Relationship Screen shot can you please see once. Then you will be understand.
 
Last edited:
Yep. I understand that... this is NOT a database.
The MAIN and SINGLE reason that each table should have a field named ID is to use THIS field as primary key (PK) in that table and as foreign key (FK) in a "child" table.
 
Okay got it but i need without remove primary key for product field in table?? Am tried DLookUp with VBA code also but not working. if any suggestion without remove??
 
please can anyone replay for how to do update product field with automatically.:banghead:
 
Let's start by you describing WHAT your business is. What are the things (entities) involved? These will become tables. How do the tables relate to each other? Tell us some of the business rules that will determine the relationships in the database.
 
Actually these Database is preparing About INVOICE BILLING purpose. I think need to give a primary key for product field in table and also relationship with order details so it is correct? Actually i need only product filed update from Brand, Model, Color fields without typing on form entry. Because Brand, Model, Color Data & Product data is same. If you don't mine can you please see before i have discussed with some guys about product filed update. After then you will understand.

Thanks for replay,
Sandya.
 
You must log in or register to reply here.

Similar threads

N
Solved How to grab the last updated record in a table
Replies
10
Views
687
June7
June7
T
Default value for field not appearing in Form. also, how to have the Default value for one of the field to "draw" from another related-table.
2
Replies
22
Views
3,437
Pat Hartman
P
C
How to automatically update/append Database Tables based on XML File being updated
Replies
3
Views
925
plog
P
C
How to Attach A VBA effectively
Replies
4
Views
1,040
theDBguy
theDBguy
A
Import DBF files and create relationships that are updateable
Replies
6
Views
1,165
AccessNovice123
A

Users who are viewing this thread

Total: 1 (members: 0, guests: 1)
Back
Top Bottom