Form Datasheet View - Double Entry

[Guest]

Hi,

When I try to use a form in Datasheet view, the data whatever i m entering
in second/third/fourth fields which are all combo box, the same data is
coming to next entry/next line. But other fields (which are not combox box)
display only one entry which is not coming into 2nd line.

How could i avoid this 2nd line? Do i want to do anything in combo box?

Pls. suggest me..

Thnx in advance.

ngr.

 

[Guest]

It usually happen when the combo/text box are not bounded to a field in the
table that the form is linked to, so the value entered dislayed in all the
records.

If that the case you need to bound this combo, so the value you are
selecting will be stored in the table

 

[Guest]

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

 

[Guest]

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery

 

[Guest]

Can u pls.specify in which event & where i need to specify in the combo box?

Thnx..

ngr..

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery
--
Good Luck
BS"D

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

 

[Guest]

Can u pls.specify EXACTLY in which event & where i need to specify in the
combo box?

Thnx...in advance...

ngr.

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery
--
Good Luck
BS"D

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

 

[Guest]

Use it on the After Update event of the combo, In the first combo refesh the
data in the second combo

Me.[Combo2Name].Requery

--
Good Luck
BS"D

Can u pls.specify EXACTLY in which event & where i need to specify in the
combo box?

Thnx...in advance...

ngr.

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery
--
Good Luck
BS"D

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

:

It usually happen when the combo/text box are not bounded to a field in the
table that the form is linked to, so the value entered dislayed in all the
records.

If that the case you need to bound this combo, so the value you are
selecting will be stored in the table

--
Good Luck
BS"D


:

Hi,

When I try to use a form in Datasheet view, the data whatever i m entering
in second/third/fourth fields which are all combo box, the same data is
coming to next entry/next line. But other fields (which are not combox box)
display only one entry which is not coming into 2nd line.

How could i avoid this 2nd line? Do i want to do anything in combo box?

Pls. suggest me..

Thnx in advance.

ngr.

 

[Guest]

Fine...Thnx...its working fine.

But, the same type of problem in other case.

From existing form, i used Double click event to open new form & then
created new name. After i created & closed the form, the new data is not
coming to the existing form where i have listed the name by combo box. But,
it is coming once i close & reopen again.

And, there is no another combo box. And, in the combo box, i listed the name
by using Table bouncing unnecessary coloumns.

How could i refresh the data in this case.

Pls.suggest me.

Thnx in advance...

ngr.

Use it on the After Update event of the combo, In the first combo refesh the
data in the second combo

Me.[Combo2Name].Requery

--
Good Luck
BS"D

Can u pls.specify EXACTLY in which event & where i need to specify in the
combo box?

Thnx...in advance...

ngr.

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery
--
Good Luck
BS"D


:

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

:

It usually happen when the combo/text box are not bounded to a field in the
table that the form is linked to, so the value entered dislayed in all the
records.

If that the case you need to bound this combo, so the value you are
selecting will be stored in the table

--
Good Luck
BS"D


:

Hi,

When I try to use a form in Datasheet view, the data whatever i m entering
in second/third/fourth fields which are all combo box, the same data is
coming to next entry/next line. But other fields (which are not combox box)
display only one entry which is not coming into 2nd line.

How could i avoid this 2nd line? Do i want to do anything in combo box?

Pls. suggest me..

Thnx in advance.

ngr.

 

[Guest]

Well, its working fine..but, when i go second line and change to new data,in
the second combo box data is getting change along with first line-Second
combo box data according to second line of first combo box.

For Example..In the first line, if i select stud_roll_no, the Sutd_name is
coming in the second combo according to selected roll_no. But, IN second
line, when i select another stud_roll_no, IInd second stud_name & the first
stud_name also get change according the second selected stud_roll_no.

I believe its clear.

What to do in this case...?

Pls.suggest me.

Thnx..in advance.

ngr.

Use it on the After Update event of the combo, In the first combo refesh the
data in the second combo

Me.[Combo2Name].Requery

--
Good Luck
BS"D

Can u pls.specify EXACTLY in which event & where i need to specify in the
combo box?

Thnx...in advance...

ngr.

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery
--
Good Luck
BS"D


:

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

:

It usually happen when the combo/text box are not bounded to a field in the
table that the form is linked to, so the value entered dislayed in all the
records.

If that the case you need to bound this combo, so the value you are
selecting will be stored in the table

--
Good Luck
BS"D


:

Hi,

When I try to use a form in Datasheet view, the data whatever i m entering
in second/third/fourth fields which are all combo box, the same data is
coming to next entry/next line. But other fields (which are not combox box)
display only one entry which is not coming into 2nd line.

How could i avoid this 2nd line? Do i want to do anything in combo box?

Pls. suggest me..

Thnx in advance.

ngr.

 

[Guest]

If you move between records then you should use the form OnCurrent event to
refresh the data in the combo's (the same requery)

--
Good Luck
BS"D

Well, its working fine..but, when i go second line and change to new data,in
the second combo box data is getting change along with first line-Second
combo box data according to second line of first combo box.

For Example..In the first line, if i select stud_roll_no, the Sutd_name is
coming in the second combo according to selected roll_no. But, IN second
line, when i select another stud_roll_no, IInd second stud_name & the first
stud_name also get change according the second selected stud_roll_no.

I believe its clear.

What to do in this case...?

Pls.suggest me.

Thnx..in advance.

ngr.

Use it on the After Update event of the combo, In the first combo refesh the
data in the second combo

Me.[Combo2Name].Requery

--
Good Luck
BS"D

Can u pls.specify EXACTLY in which event & where i need to specify in the
combo box?

Thnx...in advance...

ngr.


:

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery
--
Good Luck
BS"D


:

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

:

It usually happen when the combo/text box are not bounded to a field in the
table that the form is linked to, so the value entered dislayed in all the
records.

If that the case you need to bound this combo, so the value you are
selecting will be stored in the table

--
Good Luck
BS"D


:

Hi,

When I try to use a form in Datasheet view, the data whatever i m entering
in second/third/fourth fields which are all combo box, the same data is
coming to next entry/next line. But other fields (which are not combox box)
display only one entry which is not coming into 2nd line.

How could i avoid this 2nd line? Do i want to do anything in combo box?

Pls. suggest me..

Thnx in advance.

ngr.

 

[Guest]

Thanks a lot....Its working fine.

As you suggest, I could use the code in 'Onchange' event as there is no
'oncurrent' event for the combo box. And, I could retrive the record. But, It
is not so flexible. Suppose, suddenly if i go first line and then change
data, it is not coming properly. I need to delete the data in second combo
box, and Once or Twice i need to go back & come again from 2nd & 3rd combo
box. Then only it is coming properly.

Is there anyway to make flexible?

Further, in Second combo box, i am not able get to second data. (Note.I am
able to select, but not getting the data). Only first data is retrieving. The
data which i select second, is not coming.
For Example..in the combo list, the names are John,Smith. I could select
only John. I am not able to select Smith.

Is there anyway to select flexible data?

Pls.suggest me.

Thanks in advance.

ngr.

If you move between records then you should use the form OnCurrent event to
refresh the data in the combo's (the same requery)

--
Good Luck
BS"D

Well, its working fine..but, when i go second line and change to new data,in
the second combo box data is getting change along with first line-Second
combo box data according to second line of first combo box.

For Example..In the first line, if i select stud_roll_no, the Sutd_name is
coming in the second combo according to selected roll_no. But, IN second
line, when i select another stud_roll_no, IInd second stud_name & the first
stud_name also get change according the second selected stud_roll_no.

I believe its clear.

What to do in this case...?

Pls.suggest me.

Thnx..in advance.

ngr.

Use it on the After Update event of the combo, In the first combo refesh the
data in the second combo

Me.[Combo2Name].Requery

--
Good Luck
BS"D


:

Can u pls.specify EXACTLY in which event & where i need to specify in the
combo box?

Thnx...in advance...

ngr.


:

Try running requery on the combo to refresh the data in it

Me.[ComboName].Requery
--
Good Luck
BS"D


:

Hi,
Well.. Now there is no problem in that.

I have one more problem in that. As I mentioned already, i have three combo
box. In the second box, all the related data whatever related to combo_1 need
to come. It shows as i used query wherein i used "Form!Formname!Fieldname.

But, once i go back to previous combobox and changed the data, the second
combo data is fetching the related data. It is showing the same previous
data. But, once I closed that form & open again the new data is coming.

Even, the same case for others, if i used Double Click to open other form &
create new data from existing form, the new data is not showing. But, if i
close & open the existing form, the new data is showing.

Is there anyway to get new data from the existing form..?

Someone suggested to use 'NotinList' option. But, it helps to fire the wrong
selection / error. It not helps to retrieve the new data.

I would appreciate for your suggestion & alternation.

Thanks in advance...

ngr

:

It usually happen when the combo/text box are not bounded to a field in the
table that the form is linked to, so the value entered dislayed in all the
records.

If that the case you need to bound this combo, so the value you are
selecting will be stored in the table

--
Good Luck
BS"D


:

Hi,

When I try to use a form in Datasheet view, the data whatever i m entering
in second/third/fourth fields which are all combo box, the same data is
coming to next entry/next line. But other fields (which are not combox box)
display only one entry which is not coming into 2nd line.

How could i avoid this 2nd line? Do i want to do anything in combo box?

Pls. suggest me..

Thnx in advance.

ngr.