data find combo box problem

[deepaksharma]

Please check this form. When I set the data entry option in data tab in the property of this form as yes then the search record combo box created in the form does not work.

[Welshgasman]

Data Entry to Yes only allows you to add new records.

Try Googling ?

https://support.microsoft.com/en-gb/...0-4aa4acd8fe87

https://www.google.com/search?q=data...hrome&ie=UTF-8

Although this link states that is not the case https://learn.microsoft.com/en-us/of...form.dataentry, but anyway you do not get to see any exising records.

[deepaksharma]

Data Entry to Yes only allows you to add new records.

Try Googling ?

https://support.microsoft.com/en-gb/...0-4aa4acd8fe87

https://www.google.com/search?q=data...hrome&ie=UTF-8

Although this link states that is not the case https://learn.microsoft.com/en-us/of...form.dataentry, but anyway you do not get to see any exising records.

yes i have searched on google. nothing was found there. i want both these conditions to be at the same time. , when i turn on data entry than the combo box stops working and if i want to take service of the combo box i have turn off the data entry.

[Welshgasman]

Data entry is very badly named. Set it to no. You can still carry out data entry with new or existing records.
Understand what it is doing by reading those links.

[mike60smart]

Hi
Welshgasman has given you all the necessary information regarding DataEntry properties.

You can set the On Load properties of the Form to go to a New Record and then you can still use
the Combobox to Search

See attached

[deepaksharma]

Data entry is very badly named. Set it to no. You can still carry out data entry with new or existing records.
Understand what it is doing by reading those links.

Thank you very much, I had searched a lot on Google but I did not find such good articles, now I have understood this. I write some code in the open form event that opens the form as a blank form as soon as it is opened (kind of like a form ready for data entry) Now the problem is that actually
I have prepared a record register in which double clicking on any old record opens that record for editing in that form.
But the problem comes that if I write the coding to open a new record in the open form, then that old record is not opened because that coding triggers the opening of a new empty form and if I go to the data entry option and say yes, then the problem is solved. The solution becomes what is this?
The coding for open form is this...

DoCmd.RunCommand (acCmdRecordsGoToNew)
or
DoCmd.GoToRecord , , acNewRec

[mike60smart]

Hi
Well the problem is you need to decide what you want to do.

If you have a Form that lists all records with a Double Click Event to Open a specific Record then that is what you need to use.
Remember that the Form that Opens to display the chosen record will not need a Combobox for selecting a Record.

[deepaksharma]

Hi
Well the problem is you need to decide what you want to do.

If you have a Form that lists all records with a Double Click Event to Open a specific Record then that is what you need to use.
Remember that the Form that Opens to display the chosen record will not need a Combobox for selecting a Record.

Welcome mike,
Sorry I could not see your appearance and the file you attached.
Well actually I want that to use both options. I also want to have find combo box on the form.

[Welshgasman]

I just open a form with all records or filtered records. If I want to add a new record I use the * button.
That is for local db access backends, not remote sql servers.

[mike60smart]

OK Can you upload the database you are using for this?

[deepaksharma]

OK Can you upload the database you are using for this?

ok sir....

In this, if you make data entry yes in the form property and remove the new record code in the on load event of the form, then it will work well but when you create the "find combo box" in the main form, it will not work.

[mike60smart]

Hi Deepak

I made a couple of changes as follows:-

OfferEntry Command Button on Dashboard I added the line DoCmd.GoToRecord,,acNewRecord

I set the DataEntry to No on the Offer Entry Form
I removed the On Load event from the Offer Entry Form

Now when you click the Command Button "OfferEntry" on the Dasjboard it takes you to a New record

Now when you DoubleClick the OfferID on the FormOfferRegister it opens that specific Record

Don't see a need for any Combobox in this process.

[deepaksharma]

Hi Deepak

I made a couple of changes as follows:-

OfferEntry Command Button on Dashboard I added the line DoCmd.GoToRecord,,acNewRecord

I set the DataEntry to No on the Offer Entry Form
I removed the On Load event from the Offer Entry Form

Now when you click the Command Button "OfferEntry" on the Dasjboard it takes you to a New record

Now when you DoubleClick the OfferID on the FormOfferRegister it opens that specific Record

Don't see a need for any Combobox in this process.

hello mike,
now check the search combo box built in the "offer entry form", it is not working.

[mike60smart]

Hi Deepak
When you use the frmOfferRegister to select a specific record your are applying a Filter to the Form for that selected Record.

Now when you use the Command Button to for Offer Entry you would need to remove the Filter by clicking the Filtered Option on the Navigation Bar.
This removes the filter and now you can use the Combobox to select a specific record.

This is the best you are going to achieve.

[deepaksharma]

Hi Deepak
When you use the frmOfferRegister to select a specific record your are applying a Filter to the Form for that selected Record.

Now when you use the Command Button to for Offer Entry you would need to remove the Filter by clicking the Filtered Option on the Navigation Bar.
This removes the filter and now you can use the Combobox to select a specific record.

This is the best you are going to achieve.

Oh my genius genius genius you are absolutely right, now just navigation bar is not shown on this form, how will that happen?