By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
435,269 Members | 1,506 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 435,269 IT Pros & Developers. It's quick & easy.

Combo Box in DataSheet View Form

P: 71
Hello friends.
I am making a form to Select Some Records and then send it to Print.

I want to use a Form in DataSheet View. Using ComboBox for Selecting a Record from thousands of records.

Upon selecting from ComboBox other 5 fields must display. I want to continue it till the required quantity of Records select.

Now this form works for Only 1 Record and then tab stop. and not going
further. The logic is like this :
Expand|Select|Wrap|Line Numbers
  1. Select Received.DrawingNo
  2.      , Received.Rev
  3.      , Received.Title
  4.      , Received.Type
  5.      , Received.Purpose
  6. From Received
  7. Order BY Received.DrawingNo;
Expand|Select|Wrap|Line Numbers
  1. Private Sub Form_AfterUpdate()
  2. DrawingCombo.Requery
  3. End Sub
Why Tap stop and not going further. Where I am making mistake. Is my logic, to use DataSheet View form is correct. Please some one help.

Attached Files
File Type: zip (54.2 KB, 7 views)
Apr 8 '19 #1
Share this Question
Share on Google+
3 Replies

Expert Mod 15k+
P: 31,494
I don't believe events actually trigger in DataSheet View. Why do you want DataSheet View?

How is your code, or anything really, working towards recognising which records to include?
Apr 8 '19 #2

P: 71
Dear Neopa

For selection of records that user want to print. The data/records are in 4 figures(9999). so in datasheet view he can easily select by using combo box. Kindly open the attached file and check my logic is correct or not.
Apr 9 '19 #3

Expert Mod 15k+
P: 31,494
I'm really not sure how you can still be expecting anyone to open your database after all this time and having been told so many times that this is not how things are done.

Your question must be expressed clearly in the thread. So far you haven't managed that. I appreciate that English is not your main language, but you need to understand this is an English forum. Expecting our experts to discover what it is you're talking about by examining your database is simply not acceptable.

I repeat my question :
How is your code, or anything really, working towards recognising which records to include?

Your response so far is no answer and doesn't even give me a clue as to what we're dealing with. I need a meaningful response in order to continue to offer help.
Apr 9 '19 #4

Post your reply

Sign in to post your reply or Sign up for a free account.