Recent content by meprad

just quickly for CJ: mastertable field is Table1field. table1 is not the field of any table. Dear CJ and Paul: Thanks a lot for your heads up for providing such an important issue of using lookups. I am new to Access.. I absolutely agree with CJ that lookup is not required but I was asked to...

Many thanks CJ for your response. This database is created in Access 2010. I have Mastertable which has lookup field and other details you're interested to see which are shown in my attachment :) thanks a lot for your concern and help;) Prad

Ohh gosh! its really silly to post the unclear question for multiple times. apologies :o. I tried to make it clear through the attached diagram. I hope i made it clear there :banghead: Prad

I have two comboboxes in access form. what i want is if i select "A" from combo1, I want to have one value to combo2 could it be "x" or "y" or "z" but of my choice.. After combo1 is selected "A", I want automatically pop, lets say, "y" or any value i want may be "z" at combo2 of the form. :-)...

how to get combo2 value after updating combo1 of access form Thank you Paul, but it doesn't seem to be working, sorry for not being that clear. what i want is if i select "A" from combo1, I want to have one value could it be "x" or "y" or "z" but of my choice.. there is no link between these...

sorry again for not being that clear. Its very simple but I find this difficult - what i want is if i select "A" from combo1, I want to have one value could it be "x" or "y" but of my choice.. there is no link between these two combos. is it possible ? after updating combo1, I want automatically...

I am sorry i was not very clear on lists of combo1 and combo2. combo1 and 2 are pulled from separate tables with two columns. as described below combo1 combo2 No. Category No. Keypoint 1 A...

Dear friends, I have two combo boxes in Access form. what i want here is, lets say combo1 = "A" (selected) then I want combo2="x" (desired value to be set as "X") otherwise combo2 should remain blank. Note that combo1 has its list A,B,C and combo2 has its list X,Y,Z. Your help is well...

Dear friends, I have two combo boxes in Access form. what i want is lets say combo1 = "A" then combo2="x". Note that combo1 has list A,B,C and combo2 has list X,Y,Z. Your help is well appreciated. Prad

Dear Paul - phewww !! that rocked when code executed from "on dirty" event. does it make any difference in any way?? you are a super access hero. Millions of thanks Paul your help is really appreciated. I got exactly what i wanted. to your question if I have used code in the form; yes i used...

Thanks a lot Paul, it worked. but it returns the 'username' when I scroll the records without updating any fields in the form. How it is possible to record username only after any change made in the attribute of a form.

Thank you Dave, but don't know how and where i should write this code.. How can i get username from system after table update (using dataentry form) replacing the existing last user by the recent user. many thanks!

Dear friends, I have created access database in 2010 (windows 7) that runs in network (multiuser platform) backend in shared drive and front end in each desktops. Now i want to record user information with date who have last changed the records. I have created a field in table as "user". I have...

Hi I'm Prad. It feels great to be here in this forum for seeking help and ask questions about Access. I am quite a new to Access and will be posting a lot to find answers..will be great to catch up with you all in days to come.