473,386 Members | 1,758 Online
Bytes | Software Development & Data Engineering Community
Post Job

Home Posts Topics Members FAQ

Join Bytes to post your question to a community of 473,386 software developers and data experts.

Selecting a row in Subform

Hi!
frmOrderDetails is a subform on frmOrders.

I would like to be able to select a row in frmOrderDetails and

copy/send it to a new order/returning order.

Now I have a copy function that already copy the existing order with
its orderdetails from frmOrderDetails, into a new order with a new
Ordernr.

I also return, at this moment, the whole order by simply giving it a
running return number and mark it by a checkbox on the form, as
information
to the user and the IRS.

So, if a customer has placed an order and would like to change only
one item, I should be able to send only the chosen item (from
frmOrderDetails) to a new order or a returned order.

I could, I guess, cycle through the frmOrderDetails by:

dim intListCounter as Integer, intListItem as integer

intListItem = Me!lstMyList.Items.Count - 1

for intListCounter = 0 to etc, etc...

However, would this be a good way to do it?

Any comments/suggestions?

Me.Name
Nov 13 '05 #1
0 1159

This thread has been closed and replies have been disabled. Please start a new discussion.

Similar topics

2
by: Phil Matish | last post by:
I would like to know if the following is possible: I have a form and a subform. In the subform, there are records summarized. (For ex, instead of showing all 19 fields, I only show 3 to save...
4
by: Doslil | last post by:
I have a form which has a subform.In the main form I have only one field (this is a drop down list and has a query attached to it) which selects empno,Name from the EmployeeInformation table. ...
3
by: kevin.jonas | last post by:
What is the line of code to select the first record of a subform? I have a form with two subforms. What you select in one subform controls what is queried in the second subform. however when the...
3
by: M.L. Abram | last post by:
Hello all, I do not know if this question is regarding table design, queries, or programming. Below, I have given a table design using Access 2003. Fields 'Product' and 'Color' are primary keys...
6
by: Michael R | last post by:
Please help me with this. I have a form in which I would like to present results from a CrossTab query in a subform. I don't need the query to be bounded to a master field. Also, I have a...
8
by: anansi | last post by:
Hi I have a form called 'shiftviewer' and it contains a subform called 'all shifts for current month subform'. the subform is in datasheet view (access 2007) and the main form is a column...
0
by: keri | last post by:
I have a form for a user to enter appointments with a customer. Currently - The user enters search terms (eg name, address, town etc) in text boxes - and this filters a subform (all customers...
1
Walt in Decatur
by: Walt in Decatur | last post by:
I have a database I'm using to build information about a laboratory building design. After I create a record for a space and input general info, I move to a subform where I'd like to record any...
0
by: Rich P | last post by:
Now your question makes a lot more sense. It sounds like you want to be able to drag a group of records - say - from a subform and drop it into some control for further processing. This kind of...
5
by: kknb0800 | last post by:
Hi, I'm new to Access but I've searched for a long time for a solution but to no avail. What I'm trying to do is create an address database whereby the user is able to enter addresses through...
0
by: Charles Arthur | last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
0
by: aa123db | last post by:
Variable and constants Use var or let for variables and const fror constants. Var foo ='bar'; Let foo ='bar';const baz ='bar'; Functions function $name$ ($parameters$) { } ...
0
by: emmanuelkatto | last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud. Please let me know. Thanks! Emmanuel
1
by: nemocccc | last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
0
by: Hystou | last post by:
There are some requirements for setting up RAID: 1. The motherboard and BIOS support RAID configuration. 2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
0
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However,...
0
by: Hystou | last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
0
Oralloy
by: Oralloy | last post by:
Hello folks, I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>". The problem is that using the GNU compilers,...
0
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.