"DoCmd.OpenForm "Owner Master Form", acNormal, , , acReadOnly"
I am trying to open a form from within another form, however when i do that
the two field like for example"Owner_ID does not match Owner_ID" on the open
form.Any ideas how to correct it.
Thanks
3  4083 
On Wed, 26 Nov 2003 21:50:30 GMT, "W. Adam Glab" <wo***@sbcglobal.net>
wrote: "DoCmd.OpenForm "Owner Master Form", acNormal, , , acReadOnly"
I am trying to open a form from within another form, however when i do that
the two field like for example"Owner_ID does not match Owner_ID" on the open
form.Any ideas how to correct it.
Thanks
Use the Where argument of the method:
DoCmd.OpenForm "frmMyForm",,,"OwnerID=" & Me.OwnerID,acFormReadOnly
- Jim
DoCmd.OpenForm "Owner Master Form",,,"[Owner_ID] = " & Me!Owner_ID
--
PC Datasheet
Your Resource For Help With Access, Excel And Word Applications re******@pcdatasheet.com www.pcdatasheet.com
"W. Adam Glab" <wo***@sbcglobal.net> wrote in message
news:Ge********************@newssrv26.news.prodigy .com... "DoCmd.OpenForm "Owner Master Form", acNormal, , , acReadOnly"
I am trying to open a form from within another form, however when i do that
the two field like for example"Owner_ID does not match Owner_ID" on the open
form.Any ideas how to correct it.
Thanks
"Jim Allensworth" <ji****@Notdatacentricsolutions.com> wrote in message
news:3f****************@news.west.earthlink.net... On Wed, 26 Nov 2003 21:50:30 GMT, "W. Adam Glab" <wo***@sbcglobal.net>
wrote:
"DoCmd.OpenForm "Owner Master Form", acNormal, , , acReadOnly"
I am trying to open a form from within another form, however when i do
thatthe two field like for example"Owner_ID does not match Owner_ID" on the
openform.Any ideas how to correct it.
Thanks
Use the Where argument of the method:
DoCmd.OpenForm "frmMyForm",,,"OwnerID=" & Me.OwnerID,acFormReadOnly
- Jim This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: deko |
last post by:
This code is behind a button that exports the contents of a query
("qryXL_Tx") to an Excel spreadsheet. It works fine the first time, but
will not run a second time. When I go to look at my...
|
by: jj |
last post by:
I've got a form button that fires off 3 queries but if the first query
returns an error, I don't want the other two queries to happen.
Example: first query runs an insert from a linked table but...
|
by: Thelma Lubkin |
last post by:
formA determines some_where and some_value and issues
docmd.close ,Me
docmd.openform "formB", , ,some_where, , ,some_value
formB receives the correct some_where and some_value
After...
|
by: Mike |
last post by:
I am trying to open a search results form based on the input from a
prompt form. I am using the following code:
--- Begin Code ---
Private Sub btnSearch_Click()
'Dim Variable and assign data...
|
by: Ryan |
last post by:
Hello. I was hoping that someone may be able to assist with an issue
that I am experiencing. I have created an Access DB which imports an
Excel File with a particular layout and field naming. ...
|
by: Simon |
last post by:
Dear reader,
With the DoCmd.OutputTo ...... you have the possibility to write a
report to an external location.
In case the external location is an existing file the DoCmd is not...
|
by: RAG2007 |
last post by:
Hi
Having some problems with docmd.findrecord, getting runtime error 2162, in an adp, sql server back end.
On my main form, I have a continuous view subform giving a list of subrecords within...
|
by: natural |
last post by:
Good Afternoon
I have an option grou[ and on the after update i would like to provide the user with a msgbox, and then action
placed my docmd.setwarnings false everywhere, but i still get my...
|
by: RZ15 |
last post by:
Hi,
I frequently have code in my forms that will turn warnings off, run make table queries, then turn warnings back on using the following code:
DoCmd.SetWarnings WarningsOff
DoCmd.OpenQuery...
|
by: gazza10001 |
last post by:
Hi
i hope you can help my company uses access and has modified for its needs usually what happens is you serach for the invoice by its number and then it brings all the information up such as...
|
by: Faith0G |
last post by:
I am starting a new it consulting business and it's been a while since I setup a new website. Is wordpress still the best web based software for hosting a 5 page website? The webpages will be...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 3 Apr 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome former...
|
by: taylorcarr |
last post by:
A Canon printer is a smart device known for being advanced, efficient, and reliable. It is designed for home, office, and hybrid workspace use and can also be used for a variety of purposes. However,...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
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$) {
}
...
|
by: ryjfgjl |
last post by:
In our work, we often receive Excel tables with data in the same format. If we want to analyze these data, it can be difficult to analyze them because the data is spread across multiple Excel files...
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
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...
| |
