Hi,
I've got this problem:
I made a form, named FORM_1. This form contains addresses in several
cities.
Than I've made a second form, FORM_2, and I've put a selection-list,
named "City", on it. On this form, there is also a button, which I'd
like to execute a macro. So I linked the button to MACRO_1.
MACRO_1: action: Open Form
Form: FORM_1
Image: form
WHERE: [City]=[Forms]![FORM_2]![City]
MODUS: only-read
When I execute the Macro, I got a little window where I can type the
name of a city, and then FORM_1 shows me the right record. But when I
open FORM_2 and choose a city in the selection-list, and I use the
button to execute MACRO_1, FORM_1 opens but there's no record showed.
What am I doing wrong?
Kind regards
Karl 1 1188
Karl wrote: Hi,
I've got this problem:
I made a form, named FORM_1. This form contains addresses in several cities.
Than I've made a second form, FORM_2, and I've put a selection-list, named "City", on it. On this form, there is also a button, which I'd like to execute a macro. So I linked the button to MACRO_1.
MACRO_1: action: Open Form Form: FORM_1 Image: form WHERE: [City]=[Forms]![FORM_2]![City] MODUS: only-read
When I execute the Macro, I got a little window where I can type the name of a city, and then FORM_1 shows me the right record. But when I open FORM_2 and choose a city in the selection-list, and I use the button to execute MACRO_1, FORM_1 opens but there's no record showed.
What am I doing wrong?
Kind regards Karl
Why not execute some code instead of a macro. Ex:
Docmd.OpenForm "Form_1",,,"[City]='" & Me.City & "'"
If Form_1 is already open then
Forms!Form_1.Form.Filter = "[City]='" & Me.City & "'"
Forms!Form_1.Form.FilterOn = True This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Paul |
last post by:
Hi:
I am not sure whether somebody can sort it out for me.
I am doing data transfer from one oracle database to another. Both of
them has the same structure (like same tables etc).the only...
|
by: Rajesh Kapur |
last post by:
We use InnoDB tables and foreign key constraints extensively. The mysqldump
backs up the database tables in alphabetical order with foreign key
constraints defined in the create statement of each...
|
by: Robin Tucker |
last post by:
I'm considering adding domain integrity checks to some of my database table
items. How does adding such constraints affect SQL Server performance? For
example, I have a simple constraint that...
|
by: Dmitri |
last post by:
I just looked at a coworker's stored procedure and this person is
dropping 4 Foreign key constraints and then re-adding them after
processing the required logic (updating rows in the 4 tables in...
|
by: DW |
last post by:
Greetings:
I have to do a one-off forceful change of some data in a database. I
need to disable some FK constraints, make the data change, and then
re-enable the constraints.
My process will...
|
by: serge |
last post by:
I am doing a little research on Google about this topic and I ran into
this thread:
...
|
by: Tim |
last post by:
I have spent the last 2-3 hours trying to find a way to just list the
constraints for a given table (this includes referential - foriegn
keys, not just check constraints).
I know how to create...
|
by: BobTheDatabaseBoy |
last post by:
i've Googled some this morning, but to my surprise, i
don't find any offering (for fee or open source), which would
integrate with, say Jakarta Struts, to provide the UI
edits from cataloged...
|
by: Marek Berkan |
last post by:
Hi,
I have a problem with deffering constraints with db2. It was explained
five year ago at this same group...
|
by: Bobby Edward |
last post by:
I have an xsd dataset. I created a simple query called GetDataByUserId. I
can preview the data fine!
I created a very simple BLL function that calls it and returns a datatable.
When I run...
|
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:
If we have dozens or hundreds of excel to import into the database, if we use the excel import function provided by database editors such as navicat, it will be extremely tedious and time-consuming...
|
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: 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
|
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: 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,...
|
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...
| |