Update RecordS in Form

[imran qasim]

i have 2 tables and 2 forms

2 tables as under

1 table = personal (All Personal Info)
2 table = professional ( All Professional Skills of the person in personal)

2 forms as under

1 form = personal ( Here i put all Personal Infor of Person)
2 form = Professional ( here when i select name of the person from DropDown Box entered in Personal table it shows his nic no. automatically in next field, now here is problem if person is already added and i select his name from the drop down list his info from professional table shld be displayed also. so i can make changes in it and if there is no information added in professional table of that person then we can add them easily and like that we can easily navigate through record buy just selecting name of person from the drop downloa list)

NOTE: Sample Database is added if anyone can make changes in it

can any one help me on it???


thnxxx in advance
Take Care
ENJOY

 

[llkhoutx]

I've corrected your form Professional. Look at the VBA code, I've commented my changes.

The frm looks like you've a VB programmer. VBA is much simpler, especially in coding syntax.

Your need to uses a standard object naming convention.

The common method is detailed here.

 

[imran qasim]

Thnxxx man it works but there is still one problem left that when professional forms open it shld display first record from professional database as well as name of the person in combo box whos record is shown in professional table.

Take Care
ENJOY

 

[llkhoutx]

That's a strange way for a form to open.

I recall that I set the forms recordsource to a non-existent record on the OnOpen event. Change that to display all records, i.e. remove the criteria from the SQL string that's built OnOpen and the record associated with the first index with be displayed. Wasn't the record just "Professionals"?.

 

[imran qasim]

That's a strange way for a form to open.

I recall that I set the forms recordsource to a non-existent record on the OnOpen event. Change that to display all records, i.e. remove the criteria from the SQL string that's built OnOpen.

i didn't post with full tables here i am posting all tables and forms with data inside its creating problems with other forms & tables like if i select name from drop down and there is no record of that person but it shows first record . it shld empty boxes if the persons record is not in the table for example look in ACADEMIC form when we select name from the list it shows same record first one not of the 2nd one, kindly check this problem

thnxxx in Advance

Take Care
ENJOY